Suppress informational messages

[jeo]

I have a Before_Update event and I exit sub if date is not right. If everything checks out I open a report. Now if some data needs to be corrected before that report is open, is says DoCmd action was cancelled and I need to click OK. Is there a way suppress those informational messages to the user doesn't have to see them and/or click anything?
Thanks.

 

[maxmangion]

try

DoCmd.SetWarnings false

 

[jeo]

that didn't work...
i put it right before my exit sub...and it still brought up that message.
any ideas?

 

[maxmangion]

could you post the code that you have ?

 

[jeo]

If FTE1.Value > 1 Then
MsgBox ("FTE can't be greater than 1 for any given day")
Cancel = True
FTE1.SetFocus
docmd.SetWarnings False
ExitSub
End If
DoCmd.OpenReport "rptPersonCheckAvailability", acViewPreview

 

[maxmangion]

are you getting the warning, before the reports opens up ? if yes try to put the docmd.setwarnings statement, after the End If

 

[jeo]

Thanks...will try that.

 

[maxmangion]

you're welcome ... if it does not work, post back on it.

 

[jeo]

that worked!
thanks again for all your help.

 

[maxmangion]

you're welcome ... however, do not forget to set them on again i.e. DoCmd.SetWarnings True