I am sure this is pretty simple but I cannot figure out how to check if the data source for a form (query) is returning any data at the form's On Load event. I have tried using HasData but it seems only to apply to reports. Can anyone help? Thanks

Found the answer in the Archives

Private Sub Form_Open(Cancel As Integer)
If Me.RecordsetClone.RecordCount = 0 Then
MsgBox " No record found", vbOKOnly
Cancel = True
Exit Sub
End If

End Sub



[This message has been edited by jwindon (edited 09-22-2001).]

Thanks for your help.