Passing values to a query

[Zaz]

Hello,

I'm trying to pass a value from the field of a form to a popup window for a
query when running a report. The way I have it set up now is the user goes
into a form and selects from a set of combo boxes that keep narrowing their
possibilities. Once the users get to where they want, they run a report.
The report is based on a query that asks for certain values. Is there a way
of automatically populating what the query is asking for from the form field
values?

Thanks for any help...

 

[Rick B]

Asked and answered all the time. Put something like the following in your
query criteria...

=Forms![frmSomeFormName]![SomeFieldName]



Rick B

 

[Zaz]

Perfect! Thanks Rick...

Asked and answered all the time. Put something like the following in your
query criteria...

=Forms![frmSomeFormName]![SomeFieldName]



Rick B

Hello,

I'm trying to pass a value from the field of a form to a popup window for a
query when running a report. The way I have it set up now is the user goes
into a form and selects from a set of combo boxes that keep narrowing their
possibilities. Once the users get to where they want, they run a report.
The report is based on a query that asks for certain values. Is there a way
of automatically populating what the query is asking for from the form field
values?

Thanks for any help...