Access 2000 - Parameters with Reports

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

Guest

Please help!

I have a report that gets its data from a query. I have set up a form to
supply the parameter of 'hotel name' as a filter.

In the query criteria I have typed [Form]![Hotel Name Choice Form]![Hotel
Name]

but when I run this query it treats this as a parameter ie. a parameter
window appears with the title:

[Form]![Hotel Name Choice Form]![Hotel Name]

I want to get a report out from this just filtered by the hotel name - what
can I do?
 
The form must be open, or you'll get the prompt you're getting.

If the form is open, make sure you haven't mistyped with the form name, or
the name of the control on the form.
 
that is why i usually take variables-- like report parameters; and i
store them in variables.. and i wrap them with functions..

then get this-- you can have 2 independent forms that set the
currentproduct and you dont have to leave one form open to always know
what productid you're interested in
 
Back
Top