Report: On No Data event 1

[lbigk]

I need to cancel Open Report and Restore minimized form, if no data is available for the report. For some reason Docmd.CancelEvent doesn't want to be recognized and if I use Exit Sub, the code runs two times and still displays the report.

Any advice?
Thank you.

 

[CTOROCK]

I really don't know what data determines if it is new data for you, but you can code to open the table and do a search for, mabey today's date and if found, open report else form.restore. Or, when saving data, you can add a hidden non visible field that records when the data was inputed with Date(), then do a search. I really don't know your circumstances.


CTOROCK

 

[LarryDeLaruelle]

Look at the FAQ faq703-1594 under Reports/FAQ's.

Found it just the other day and it was just what I need. May do the trick for you. Larry De Laruelle
ldelaruelle@familychildrenscenter.org