evaluating null record sets

[lrmac93]

i want to open the form and display records, but if there is no record in the form i don't want to display form. what properties are available to recognise when a form's recordset is null?

 

[tman138]

Probably the easiest way is to do a DCount on a column in the underlying recordset.
If DCount("[mycolumn]","myTableorQuery&quot>0 then DoCmd.OpenForm "MyForm"
Else
MsgBox "There are no records to edit!"
End If

Or something like that!

Hope this helps...T

 

[lrmac93]

i've tried your suggestion and although the message box appears when there is no records, the empty form still appears after you close down the message box.

 

[tman138]

Where are you inserting the code? The best place would be external to the form you want to open, if not you will have to insert an exit function command and a docmd.close command to both exit the code and close the form.

 

[lrmac93]

tman,
that's worked a treat. thanx for the help

lrmac93