OnNoData for my form

B

Bonnie

Hi there. Using A02 on XP. Love the OnNoData Event for
reports. But, I have a form that I would like to show a
message when there are no records and cancel the form open
event. Otherwise, go ahead and open. How is it best to do
this? Thanks in advance for any help or advice.
 
F

fredg

Hi there. Using A02 on XP. Love the OnNoData Event for
reports. But, I have a form that I would like to show a
message when there are no records and cancel the form open
event. Otherwise, go ahead and open. How is it best to do
this? Thanks in advance for any help or advice.
Click to expand...

In the form's Open event:

If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "No Records"
Cancel = True
End If
 
B

Bonnie

Excellent! Thanks SSOOOOOOO much!
-----Original Message-----


In the form's Open event:

If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "No Records"
Cancel = True
End If

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Top