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