Query with multiple fields and one form

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
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Multiple Parameter Crosstab query filter by form 1
Copy previous record into form field 0
form needed request 0
Display Query Results on top of a Form 1
Query Question 1
Form queries from multiple tables 4
Query using multiple values from one text box 8

Top