how check for no data when opening continuous form ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how check for no data when opening continuous form ??

The empty form looks bad and I'd like to put out a message. But there is no 'OnNoData' event like in a report?
 
There is probably a better way. However in case you don't find it how about
opening a recordset based on the query supporting the form. Then check the
record count?


--
My handle should tell you enough about me. I am not an MVP, expert, guru,
etc. but I do like to help.


David said:
how check for no data when opening continuous form ???

The empty form looks bad and I'd like to put out a message. But there is
Click to expand...
no 'OnNoData' event like in a report?
 
AnExpertNovice said:
There is probably a better way. However in case you don't find it how about
opening a recordset based on the query supporting the form. Then check the
record count?
Click to expand...


That's very close, but you don't need to open a recordset.
The form's RecordsetClone already exists.

If Me.RecordsetClone.RecordCount > 0 Then
' There's at least one record
Else
' NoData
End If
 
Back
Top