Access auto close a report with no data - TechRepublic
General discussion
July 7, 2004 at 09:04 AM
d_bones

Access auto close a report with no data

by d_bones . Updated 22 years ago

Easy one for you clever people but it’s driving me mad.

If yo create an “OnNoData” event procedure for a report and the enter the event as DoCmd.Close “repName”. You get a debug error.

How can you not display a report wih no data when using

DoCmd.OpenReport “repName”, acViewPreview

All help gratefully received. As usual

This discussion is locked

All Comments