Text Box Search

[Stang02GT]

I currently have my searches on forms being done by combo boxes. After meeting with the users, they would like to see a txt box search.

This is what I need help with:

I have two ID Fields that the users can search by, some records have both ID's some only have one so i have to include both.

What the users would like to see is, two text boxes where they can enter an ID and click a Search Button, to bring up the records.

I'm not really sure on how to go about doing this, so any help will be greatly appreciated!!!

[NeoPa]

I suggest that you start out by posting your table MetaData. This will help us to help you. Here is an example of how to post table MetaData :
Table Name=tblStudent

[i]Field; Type; IndexInfo[/i]
StudentID; Autonumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time

[NeoPa]

An article you may find interesting on the subject is Example Filtering on a Form.