Query with multiple fields and one form

Hello,

I have a database that has a form "Bluebook" and a corresponding table
"Bluebook". On the form, i have a button that says Query and when clicked,
it opens a form that allows the user to query from four different fields.
How do i make it so that when the user hits the "ok" button on the query
form, the Bluebook form is filtered so that only the results of the query
are displayed?

Thanks for your assistance!
Evan McCutchen
evan AT radiologyonesource DOT com

When the user clicks OK on the second Form (Dialog mode recommended), you
can set the Filter Property of the 1st Form according to the criteria
constructed from entries on the second Form and then set the FilterOn
Property (of the First Form) to True to activate the filter.

Check Access VB Help on the Filter and FilterOn Property.

--
HTH
Van T. Dinh
MVP (Access)



"Evan McCutchen" wrote in message
...
Hello,

I have a database that has a form "Bluebook" and a corresponding table
"Bluebook". On the form, i have a button that says Query and when clicked,
it opens a form that allows the user to query from four different fields.
How do i make it so that when the user hits the "ok" button on the query
form, the Bluebook form is filtered so that only the results of the query
are displayed?

Thanks for your assistance!
Evan McCutchen
evan AT radiologyonesource DOT com