By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 981 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Creating a form that creates a unique query

P: n/a
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

May 2 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


May 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.