Forms and Parameters URGENT

L

Lozza0409

Hi, i have a form which allows users to input start date and end date. This
then runs a query on the criteria. What i want to be able to do is show the
results in another form so that the user can view the results in a form and
make amendments if required. I preferable want this is be a sub form which i
will link to the master form.
Many thanks, i hope someone can help me asap!
 
J

John Webb

You could set the subforms control source to be a query, and put the
form field in the criteria for that query. Then you would simply need
to requery the sub form once the dates have been entered.

Cheers

John
 
L

Lozza0409

John Webb said:
You could set the subforms control source to be a query, and put the
form field in the criteria for that query. Then you would simply need
to requery the sub form once the dates have been entered.

Cheers

John
Click to expand...
Thanks Ill try that. How to you run the requery function? Is it in VB or
run a macro? Does this function just run the query?
 
Top