If a forms underlying query has no results, can I close the form automatically. How?
J Joe Mar 23, 2005 #1 If a forms underlying query has no results, can I close the form automatically. How?
J JaRa Mar 23, 2005 #2 Yep this will do it : Private Sub Form_Open(Cancel As Integer) If Me.Recordset.EOF Then DoCmd.Close acForm, Me.Name End If End Sub - Raoul
Yep this will do it : Private Sub Form_Open(Cancel As Integer) If Me.Recordset.EOF Then DoCmd.Close acForm, Me.Name End If End Sub - Raoul
J Joe Mar 23, 2005 #3 Thank you so much Raoul. It worked perfectly! JaRa said: Yep this will do it : Private Sub Form_Open(Cancel As Integer) If Me.Recordset.EOF Then DoCmd.Close acForm, Me.Name End If End Sub - Raoul Click to expand...
Thank you so much Raoul. It worked perfectly! JaRa said: Yep this will do it : Private Sub Form_Open(Cancel As Integer) If Me.Recordset.EOF Then DoCmd.Close acForm, Me.Name End If End Sub - Raoul Click to expand...
