I'm trying to create a form where by I can enter a company name in a text box, click find and a another screen displays the results., Possible??! Any tutorials?!
create a query with the criteria...
[forms]![formname]![nameoffield]
Then create a form that returns the records for this query.
finally insert the new form as a subform in your desired form.
you will need to requery the subform every time you enter a new value
using "Me![subformname]![name of list box].requery".
This depends on how you return the records...ie a button or return button etc.
A button would be good. O the onclick event of the button...put in the code above for requery
YOu may also want to view my last two posts which are all about searching. Hope this helps you!!