no data handling

[legendv]

Does anyone know how to close a form if no data is found upon opening?

 

[SteveA]

In the OnOpen event of the form you can check to see if there are any records to display. If not, you can cancel the Open event.

Sample code:

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

Hope this helps.

SteveA

 

[legendv]

thanks steve!