stop system message appearing

[tizwaz]

I have put the following code on the on click event of a button However although my msg box appears it is still followed by a system msg 'the action or method requires a report name argument'. How can I stop this appearing?

If IsNull(Me.cboReportType) Then
MsgBox "You must select the report type"
DoCmd.SetWarnings False
Me.cboReportType.SetFocus
End If

 

[PHV]

Add Exit Sub after the SetFocus call.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tizwaz]

brilliant - thanks works fine now