entering query criteria via a form

Can anyone help please
[a]
I need a way of editing queries that is easy for a novice user (via a form )instead of directly editing the query itself.
Scenario
I have a table of five fields, one holds the age field (number format) with five records
create a simple query with no criteria from the table
Now i want a form which the user can use to query the table to show the field but the user should be able to enter
in any number in the age field to query the table to bring up all the resulting records that have the entered number value
from the age field

Basicaly there would be an enter query form with a button which should then open up the resulting query depending on the
criteria entered. Thus making it easy for the user to easily edit the query
[b]
another similar problem is a form to query a database to check for records that fall between two dates eg. from x to x
I want the user to enter the crietria via a form instead of editing the query which is not flexible for the scenrio i want

Hi asenguah

[a]
Place a text box on your form for the user to enter the age in. Then in your query design in the criteria row below the age field place this syntax:

Forms![FormName]![TextBoxName]

Use your form name and the text box name that you use on your form. This will open the query filtered by what the user typed in the textbox.

[b]
Place two text boxes on your form. Give one the name of StartDate and the other the name of EndDate. Then in your query design view in the criteria under the date field place this syntax:

Between [Forms]![FormName]!BeginningDate] And [Forms]![FormName]![EndingDate]

Just use your form name.

lwells

Thank you Iwells

Iwells,

I did this, several times in fact, and get it to work. But when I close my database and reopen it, it doesn't work. I don't get why it forgets what to do, lol. I'm running Access 2007.
Thanks.

-Ben

Look at this tutorial. It may help you to get there

http://www.datapigtechnologies.com/flashfiles/searchform.html

Alan

When I try entering "Forms![FormName]![TextBoxName] " into the criteria in design (or for that matter SQL view) in Access 2003, it changes my syntax to:

[Forms]![FormName]![TextBoxName]

And then when I try to run the query I get a crieria popup with the text:

'Forms!FormName!TextBoxName'

which needless to say isn't what I want. What I am trying to do is to use a combo box from a form.

Can anyone advise what I am doing incorrectly?

Thank you!! This tutorial is a great way of constructing a form query!

RealNeal,
In place of TextBoxName, put the name of whatever field/control on your form you want to use as criteria. TextBoxName is a generic reference just for the example.