Close Report and Cancel if there are no records.

C

Carl Mankat

I found how to do this for forms using RecordsetClone.RecordCount = 0
and using Cancel = True.

How can I do the same thing for a form?

TIA,

Carl
 
M

Marshall Barton

Carl said:
I found how to do this for forms using RecordsetClone.RecordCount = 0
and using Cancel = True.

How can I do the same thing for a form?
Click to expand...


For a report, use the NoData event:

Cancel = True

The report will not display, but you will get an action was
cancelled message. If you opened the report from VBA code
in a form's event procedure, you can trap error 2501 and
ignore the error. If you need help with this, post the form
procedure that opens the report.
 
C

Carl Mankat

Thanks, I tried that and it gave me what I was after. Will Access Help
give me anything about Cancel?

TIA, again,

Carl
 
M

Marshall Barton

Cancel is mentioned in the NoData Event topic in A03, but it
doesn't say any more than setting it to True prevents the
report from printing.

If that's all you do, pretty soon you will notice the pop up
message. Most people don't want to see this so I Suggested
the way to suppress the message.
 
Top