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?!