I have 5 different reports in my data base . How can i use a combo box in a form to open these reports one by one? is there any vba code to do this ? please help...
Novice
Windows XP 
Access 2007
To open reports using a combobox in a form
I have 5 different reports in my data base . How can i use a combo box in a form to open these reports one by one? is there any vba code to do this ? please help...
Access Developer
Windows 10 Access 2019
Populate the combo with the name of each report. Use in the AterUpdate event of the combo:Code:DoCmd.OpenReport Me.ActiveControl, acViewPreview
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Excess Access
Windows 11 Access 2019
Have a look here:
Report Manager for Access (accessforums.net)
Novice
Windows XP Access 2007
Thank you very much Sir . Your report manager works properly .
Excess Access
Windows 11 Access 2019
Quite welcome. Glad to help.Originally Posted by vsk1975
Open form to record # in ComboBox
Combobox to open a form to selected record
Use combobox to select form to open
Posting Permissions
Reply With Quote