empty form opens-BAD

[Beth]

What is the method to prevent the opening of a form when
no record exists in that recordset?

Please note: I call the form to open with a command
button that is on an UNBOUND form.

Using HasData does not work as I have used it. It works
well for me when the calling form has a recordset, thus a
field to test that I can point to, but the calling form
is UNBOUND. What to do?

Is there a modification to be made to HasData? Another
method?

Any help is appreciated. This is frustrating.

Beth

 

[JohnFol]

If the form is unbound, then by definition it has no data .. .. .

 

[Jeremiah Ellison]

Private Sub Form_Open(Cancel As Integer)
If Me.RecordsetClone.RecordCount < 1 Then Cancel = True
End Sub

What is the method to prevent the opening of a form when
no record exists in that recordset?

Please note: I call the form to open with a command
button that is on an UNBOUND form.

Using HasData does not work as I have used it. It works
well for me when the calling form has a recordset, thus a
field to test that I can point to, but the calling form
is UNBOUND. What to do?

Is there a modification to be made to HasData? Another
method?

Any help is appreciated. This is frustrating.

Beth

Jeremiah Ellison
Ellison Enterprises - Your One Stop IT Experts