findrecord not working with numbers

QueenKirsty

Registered User.
Local time
Today, 07:07
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:

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?
 

Users who are viewing this thread

Back
Top Bottom