davidquested
03-19-2001, 09:46 AM
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?!
|
View Full Version : How do I create a search form?! davidquested 03-19-2001, 09:46 AM 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?! Misanthrope 03-19-2001, 10:24 AM 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!! davidquested 03-20-2001, 08:58 AM Can't get this to work, it complains about the absence of the correct Macro!? |