Passing values to a query

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

Guest

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...
 
Asked and answered all the time. Put something like the following in your
query criteria...

=Forms![frmSomeFormName]![SomeFieldName]



Rick B
 
Perfect! Thanks Rick...

Rick B said:
Asked and answered all the time. Put something like the following in your
query criteria...

=Forms![frmSomeFormName]![SomeFieldName]



Rick B


Zaz said:
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...
Click to expand...
Click to expand...
 
Back
Top