Msgbox Message

[Guest]

Hello,

I am trying to add a Msgbox that if an Item is not select
in the option box then say need to check a report. How
can I do that? Thanks

 

[Nick Hoare]

Hello,

I am trying to add a Msgbox that if an Item is not select
in the option box then say need to check a report. How
can I do that? Thanks

The easiest thing to do is set a default value for your option group.
If not then add code like this to the OnClick event of the button that
the users press to run the report.

If IsNull(Me.Frame0) Then 'Frame0 is the name of the Option group
MsgBox "choose something"
Exit Sub
End If