Query with multiple fields and one form

  • Thread starter Thread starter Evan McCutchen
  • Start date Start date
E

Evan McCutchen

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.
 
Back
Top