Fantastic! Works perfectly. I spent the whole day yesterday trying to get this to work properly. Thank you so very much.
I did update it as follows to open the Report View:
Private Sub cboRpt_AfterUpd ate()
DoCmd.OpenRepor t cboRpt, acViewReport, , , acDialog
End Sub
Melody Rivera
Last Activity: Jan 7 '11, 08:50 PM
Joined: Jan 7 '11
Location:
-
Melody Rivera started a topic Open a specific report from a drop down box (not based on any criteria)in AccessOpen a specific report from a drop down box (not based on any criteria)
I want to create a drop down box that allows the user to open a specific report.
I want to list only certain reports and to list them by a user friendly name (not the back end naming convention that is not meaningful to the user).
These reports are already written and run on a query that is already written, the user is not running the report based on criteria just opening the report, preferably in report view not print...
No activity results to display
Leave a comment: