Query to a form

[lee_morgan]

Any ideas as to why I can't see the fields from my query in my form biut when I use a table I can see them all??

 

[ghudson]

Your SQL [record source] is not returning any records. When that happens the forms sometimes load blank.

 

[lee_morgan]

Your SQL [record source] is not returning any records. When that happens the forms sometimes load blank.

Is there anything that I can do to stop this??

 

[ghudson]

Put this in your forms OnOpen event...

Private Sub Form_Open(Cancel As Integer)
    
    If Me.RecordsetClone.RecordCount = 0 Then
        MsgBox "There are zero records in the data source!", vbInformation, "No Records Found"
        DoCmd.Close acForm, Me.Name
    End If
    
End Sub