go to record in a form - find by field value (1 Viewer)

[cargobay 69]

OK, my simple little form simply inputs data into a table containing thousands of records. Is there a way to put a control onto the form that will allow the user to go directly to a record where the value of a particular field is equal to a value entered by the user?

Say, for instance, the user clicks a button, a dialogue box appears prompting the user "Enter Lot Number:", then the user can type in the lot number, click OK and be taken to the first record where "Lot_number.Value" equals the input value.

I do not want to open a seperate form nor do I want the source table to be filtered upon execution of the search, just go to the record.

Can it be done?

Thanks
DH

 

[KevinM]

Use the comboWizard and select the 'Search records in my form' option. Follow the on screen dialog boxes and use your Lot Number field in the column.

HTH

 

[cargobay 69]

Thank you, Kevin. That worked great.