Madmart1gan
Registered User.
- Local time
- Today, 12:57
- Joined
- Mar 19, 2014
- Messages
- 12
I have a form with two cascading list boxes. When the selection in the final list box is made, the user presses a button that opens a report using a macro on the button. I'm trying to create an If statement in the macro that says, if no selection is made in the final list box, display a message box and stop the macro, otherwise, open the report.
I'm just not sure how to properly execute that. I tried
I think I'm just not getting that If statement correct. Any ideas?
I'm just not sure how to properly execute that. I tried
Code:
[COLOR=red]If [Forms]![fReportBuilder]![cmbo_SelectFactSheet] Is Null
[/COLOR]
[I]Then Message Box[/I]
[I]Stop Macro[/I]
[I]Else[/I]
[I]Open Report[/I]
I think I'm just not getting that If statement correct. Any ideas?