Forms and Parameters URGENT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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?
 
Back
Top