Drop Down List on a Report

G

Guest

The user would like a drop down list on the report to select the specific
information and when selecting gives only that information on the report.
The report is pulled from one query. I have made a quick fix for this
utilizing the Like [Enter Org Unit] in the query field and this pulls only
that information into the report after the user types in the value. Is there
a way to place a drop down listing on the report? How do I go about doing
this? Thanks
 
B

benyod79 via AccessMonster.com

Can't do dropdown lists in reports.

Create a "report" form with a dropdown "OrgUnit" that lists the unique Org
Units. In the dropdown's afterupdate event, create an event procedure and
call the report using:

DoCmd.OpenReport "YourReportName", acViewPreview, , "[Org Unit] = '" & Me.
OrgUnit & "'"



The user would like a drop down list on the report to select the specific
information and when selecting gives only that information on the report.
The report is pulled from one query. I have made a quick fix for this
utilizing the Like [Enter Org Unit] in the query field and this pulls only
that information into the report after the user types in the value. Is there
a way to place a drop down listing on the report? How do I go about doing
this? Thanks
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Box 2
Having a drop down combo box preceed the running of a report 5
Select from Drop down list 1
report and drop down lists? 6
Report exporting different data from what is on the report 1
Report from drop down menu 5
Access Report - Field to toal Group Totals 1
Cross Tab Report Vs Dynamic coulmns 0

Top