Forms for looking up information

[omeara4pheonix]

I am trying to create a form that will lookup and display information after a user input. Specifically I have a table with one field which is a list of lot numbers of products, and several other tables containing test results and their corresponding lot numbers, all lot number fields are related and have to be contained in the table dedicated to lo numbers. The user will input a lot number and the form would export test results, how would i go about doing this?

[Stingaway]

Quick and dirty way is to create a parameter query tied to an input text field on a form.

In the query you would put in the lot number field and for the criteria put in "=[Forms]![frm_name]![txt_name]" (no quotation marks) where frm_name is equal to your form's name and text name is equal to the text element on the form.

[alansidman]

Stingaway is on target here. Here is a tutorial expanding on what he is suggesting.

http://www.datapigtechnologies.com/f...earchform.html

[omeara4pheonix]

Ok I was working on doing that but how would I make the values returned by the query display in the form after a lot number has been entered?

[alansidman]

You will have to create a subform with the recordsource the query. Insert the subform into your mainform as a datasheet.

[omeara4pheonix]

I tried that but it stays blank (the subform) even after the query runs. How do I make that data show?