How do I create a search form?!

  • Thread starter Thread starter davidquested
  • Start date Start date
D

davidquested

Guest
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!!
 
Can't get this to work, it complains about the absence of the correct Macro!?
 

Users who are viewing this thread

Back
Top Bottom