Access report, variable input-how to take input from other query?

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

Guest

I have an access query which generates a report based on the user entering a
value for one of the fields (@session).
Rather than have the user type in the value of @session, I would like them
to a value from a list box. The list box should be populated by another
query which lists the unique values availalable for session.
 
MP:

It sounds as if you are using an ADP database. If you look at the sample
northwind ADP that comes with Access, and the sales by year example you can
see how the input parameters field of the report references a form. Of
course you can then use a different view to populate the combo box on the
form.
 
Thanks for the reply Bob, took a while, but I did get round to implementing
it. It's working beautifully.
Just one small change I had to make in the query itself, it didn't work if I
used the box name, so I just used Forms![form name].

Bob Miller said:
Create a form with your listbox on it and a button to run your report.
In the Criteria for @session in your query place:
Forms![from name]! box name .
Open the form, select from the listbox and click the report button

MP said:
I have an access query which generates a report based on the user
entering a
value for one of the fields (@session).
Rather than have the user type in the value of @session, I would like
them
to a value from a list box. The list box should be populated by
another
query which lists the unique values availalable for session.
Click to expand...
Click to expand...
 
Hi Steve, thanks for the reply, I'll take a close look at that sample
database, sound quite usefull.
 
Back
Top