mpaulbattle
Registered User.
- Local time
- Today, 17:30
- Joined
- Nov 30, 2017
- Messages
- 56
Is there a way to open the report the user selected in the combo box?
I created a form with a combo box (cboCannedReports) and listed three reports:
1. Completed Closures
2. Pending Closures
3. All Closures
I came up with something like this
but that is not working. I would like to think there is probably going to be some If statements. Is this close to what I need? Looked at some Google examples but couldn't find anything.
I created a form with a combo box (cboCannedReports) and listed three reports:
1. Completed Closures
2. Pending Closures
3. All Closures
I came up with something like this
Code:
DoCmd.OpenReport "rptPracCloseCompleted",acViewNormal,,,Me.cboCannedReports)
but that is not working. I would like to think there is probably going to be some If statements. Is this close to what I need? Looked at some Google examples but couldn't find anything.