Query accept input from Form

dickohead

Registered User.
Local time
Today, 19:21
Joined
Dec 7, 2005
Messages
42
Hey Folks,

I have a form that has two things on it:

A button to open a query
A list box with names in it

How do I get the query so that it will select all records where the name field matches the chosen name from the list box?
 
In the Query Criteria put:
[Forms]![FormName]![FieldName]
 
You are a life saver! It's the [Forms] bit that stuffed me!

Thank you HEAPS!!!

*big hugs*
 

Users who are viewing this thread

Back
Top Bottom