Message Box before opening rpt

[Guest]

I have a report that is created when a user selects a Command Button in a
menu. I've added a 'Private Sub Report_NoData' message that displays when
there isn't any data. I want to display a different message that describes
what the report is for ... so it's not used for the wrong purpose. Something
to the effect 'INPUT LAST VALIDATION DATE AS CRITERIA'. How do I do this?

I'm using Access 2002. I have searched the discussion groups and can't find
an answer to my question. Thanks in advance for your help!

 

[Peter R. Fletcher]

Put the message box code in the Report's OnOpen event.

I have a report that is created when a user selects a Command Button in a
menu. I've added a 'Private Sub Report_NoData' message that displays when
there isn't any data. I want to display a different message that describes
what the report is for ... so it's not used for the wrong purpose. Something
to the effect 'INPUT LAST VALIDATION DATE AS CRITERIA'. How do I do this?

I'm using Access 2002. I have searched the discussion groups and can't find
an answer to my question. Thanks in advance for your help!

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[Guest]

That did the trick ... now for another question ... how do I display a
message in a QUERY that will then allow the user to cancel the query if they
don't want to run it?