HELP!!!! I have a form with a combo box to select "Staff ID" and a
Calendar which puts the selected date into my "Date" field. These two
fields are the criteria for my parameter query. This works fine!!! :)
the problem is that i want to use the same query with 2 different
forms...so i thought i could set the criteria as the name of the field
in the first tabel then use "Or" and put the name of the field in the
second form, but when i run the query it wants both..can anyone help??

thanks

You may want to create/recreate the query for each instance. After
the user updates their selection change the sql or perhaps query def
to insert that value.

That saves you the problem of having to manage references to forms
that may or may not be open - always a problem

On Apr 17, 9:19=A0am, crispydcr... [at] googlemail.com wrote:
> HELP!!!! I have a form with a combo box to select "Staff ID" and a
> Calendar which puts the selected date into my "Date" field. These two
> fields are the criteria for my parameter query. This works fine!!! :)
> the problem is that i want to use the same query with 2 different
> forms...so i thought i could set the criteria as the name of the field
> in the first tabel then use "Or" and put the name of the field in the
> second form, but when i run the query it wants both..can anyone help??