Misanthrope
03-16-2001, 01:41 PM
What I want to do is: Enter data in a text box and have all data in a record(s) matching the text returned in a list box. Can I do this?
|
View Full Version : HELP!!!!PLEASE!!! Misanthrope 03-16-2001, 01:41 PM What I want to do is: Enter data in a text box and have all data in a record(s) matching the text returned in a list box. Can I do this? Anauz 03-19-2001, 08:50 AM yes you can 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 [This message has been edited by Anauz (edited 03-19-2001).] davidquested 03-20-2001, 12:59 AM When I use the above example, I click on the button and it complains about this not being a macro event?! Any ideas?! |