Query / Form - user enter

[Jorge]

Hello

I have created query in which I display the several dates based on payroll
end of week.
The table has a years worth of dates.

I know how to edit the query etc to enter the criteria needed.
But the user(s) do not! I'd like the user to select the query and it prompts
them for a date, the date is entered in the criteria for the query. Voila'
the query runs - giving the proper answer.

I also based a form on this query so I was hoping it will do the same
thing...

Thanx in advance..
Jorge

 

[Anne]

Jorge,
You have to enter a parameter in your query.
Select the field where you enter your date criteria. In the criteria
section, enter something like [Please enter the Payroll Date
(DD/MM/YY)].
When the user open the query, he will be prompt with the message in
the brackets. In fact the brackets create the parameter.

Now if you want to update it from a form, this is easy as well:
Let's say your form is called frmPayroll and the control with the
Payroll date: PayrollDate.
In the criteria of the date field in your query enter:
FORMS!frmPayroll!PayrollDate
The query will use the date in the control as a criteria. Make sure
that the control is not null.

Anne