searching form by serial number

[GregB]

In my previous database I had users prompted with a dilaog box to put in user
parmaters and the information would be gernerated that way.

Now
I want to have form box that lets the user type/scan in serial number
and
have a subform that corrleates to the typed/scanned number and displays the
assoicated information.

What is the best way to go about this?


Thanks for any direction. Thanks!

 

[Ken Snell \(MVP\)]

Put a textbox on the main form (call it txtSN). In the subform's
RecordSource query, add a criterion for the field that contains the serial
number:
[Forms]![YourMainFormName]![txtSN]

In the after update event of the textbox txtSN, requery the subform on the
main form.

Let us know if you need additional info.