Find records using combo box and text box

[ihaveaquestion]

I have a form (Contacts) with a combo box (namefinder) and a text box (idfinder), both of which are intended to store a integer value that corresponds to the field, "ContactID". I want to be able to use either option to find the record that matches.

I had this working great when I had only the combo box. The bound column was "ContactID" but the visible columns were "Fname", "Lname". I set the Record Source for the form putting this criteria under ContactID:

Like [forms]![Contacts].[namefinder] & "*"

The text box will allow users to enter the ContactID and go to that record. But I can't figure out how to do this. Anyone know the solution? Maybe something in the form Record Source?



Any help is appreciated! Thank you!

[June7]

Never seen anyone try this.

Is ContactID an autonumber field? Why are users even aware of ContactID? Why should they even need to search by this?


Maybe:

Like Nz([forms]![Contacts].[namefinder], [forms]![Contacts].[idfinder]) & "*"