HELP!!!!PLEASE!!!

Misanthrope

New member
Local time
Today, 13:42
Joined
Mar 16, 2001
Messages
5
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?
 
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).]
 
When I use the above example, I click on the button and it complains about this not being a macro event?! Any ideas?!
 

Users who are viewing this thread

Back
Top Bottom