test for no data in form

[jeffmoore]

I have a form that is opening a second form that has the addnew property set to false. If the user clicks on the button and there is no record for that form it displays a blank form (no controls on it).
Q: Is there an event like the NoData event (in reports) for testing for the above condition.

OR do I have to go thru the process of opening a recordset testing for .eof and .bof.

Just looking to see if there is an elegant way to do this
TIA
Jeff

 

[john2thompson]

Don't think there is an event that would meet your needs, but might be wrong.

Still performing a simple .bof and .eof or DLookup statement on the command button click wouldn't provide too many difficulties.

Regards,
John