Creating a form that creates a unique query

[joepollard]

For a project I have been asked to create a database system for use in
an Estate Agents.

Obviously the main function of such a system would be the need for a
user to seach through the database for properties that match a certain
set of criteria. The problem is this: I need to create a form that
allows a user to select for each field of data held about the property
a value. For instance someone wants to seach for A house with 2+
Bedrooms, that costs below £150,000. The number of criteria could be
less or more, however I need to be able select as few or as many
critera on one form (obviously only from criteria I am holding about
each property).

So basically, I need a form that creates a query and runs it for each
time it is opened and edited. Any ideas on the best way to go about
this?

Cheers

[Tom van Stiphout]

On 2 May 2006 06:15:00 -0700, jo********@gmail.com wrote:

If you're a rookie, you may want to look into Records > Filter >
Filter by Form

-Tom.

For a project I have been asked to create a database system for use in
an Estate Agents.

Obviously the main function of such a system would be the need for a
user to seach through the database for properties that match a certain
set of criteria. The problem is this: I need to create a form that
allows a user to select for each field of data held about the property
a value. For instance someone wants to seach for A house with 2+
Bedrooms, that costs below £150,000. The number of criteria could be
less or more, however I need to be able select as few or as many
critera on one form (obviously only from criteria I am holding about
each property).

So basically, I need a form that creates a query and runs it for each
time it is opened and edited. Any ideas on the best way to go about
this?

Cheers