Record check before opening report

[astarbyfar]

Hi, I have a report which is generated on a query called Tool Room. I then have a button which allows a user to simply click and print of the neccessary report. Now what Im wondering is there a way that when the user clicks on this button a check is done to see if there are any records generated from the query. If there is then the report will simply print of, and if there isnt an OK warning message will be displayed which will redirect the user back to the menu form with this button on.

Hope this makes sennse

Regards

 

[RV]

Put this in the On NO Data event of the report:

MsgBox "No data found"
Cancel = True

RV

 

[astarbyfar]

Thanks, the way I was thinking was far more difficult. Thanks alot

Regards