Form lookup field on table

[MrMitch]

I have a form that I have employees use to enter dates for specific records. Right now they have to use buttons to move back and forth between records. Is there a way to have it so they could enter data in a field that would pull up specific records based on what they type in rather then having them use these buttons to browse?

 

[pbaldy]

Have you tried the combo box wizard, choosing the third option, "Find a record..."?

 

[MrMitch]

Paul, I am using 2007. I am only seeing 2 selections through the wizard.

1. "Look up the values in a table or query"
2. "I will type in the values that I want"

 

[pbaldy]

The form has to be bound to a table or query for the third option to appear (including 2007). I assumed yours was, since you said they were browsing records on it.

 

[MrMitch]

Paul,

I am sorry, I was working on another project and got confused. You are correct, and what you suggested works fine. Thanks for your help.

 

[pbaldy]

No problem; I've done the same thing many times.