How to setup a multi-variable query driven by a form

[Andy]

I would like to set up a userform that gives the user
specific options to select:
Bedrooms: 1 or 2
Patio: True or False
Balcony: True or False
Corner Apt: True or False
Floor: 1 or 2 or 3
Front Side: True or False

From this, a "generic" query that uses the user's
selections above to provide a list of apartments that
meet the criteria (i.e. A 2 bedroom apartment, with a
patio, that is a corner apartment on the 2nd floor).

Any help would be much appreciated.

Andy

 

[Dan Artuso]

Hi,
Just refer to this form in the criteria fields of your query in design view.

So for your Patio field:
Forms!yourFormName!yourPatioControl

Bedroom:
Forms!yourFormName!yourBedroomsControl

etc

HTH
Dan Artuso, MVP

 

[Guest]

Thanks Dan. What you have makes sense, I'll try it out.

Andy

-----Original Message-----
Hi,
Just refer to this form in the criteria fields of your query in design view.

So for your Patio field:
Forms!yourFormName!yourPatioControl

Bedroom:
Forms!yourFormName!yourBedroomsControl

etc

HTH
Dan Artuso, MVP

"Andy" <[email protected]> wrote in

message news:[email protected]...