QueenKirsty
Registered User.
- Local time
- Today, 19:58
- Joined
- Mar 13, 2009
- Messages
- 31
I have a popup dialog box that takes an input and then uses it to find a record on the previous screen. The code for the popup is as follows:
This works fine with text fields but when I try to add acAnywhere to the findrecord command it will not search on number fields. I need the acAnywhere so that I can search partial terms.
Any ideas?
Code:
dim searchTermGlobal as variant
If Not IsNull(Me.inputTxt) Then
searchTermGlobal = Me.inputTxt
DoCmd.Close acForm, "shortcutSearchBox", acSaveNo
Screen.ActiveControl.SetFocus
DoCmd.FindRecord searchTermGlobal
End If
This works fine with text fields but when I try to add acAnywhere to the findrecord command it will not search on number fields. I need the acAnywhere so that I can search partial terms.
Any ideas?