Problem with isnull

[Susan Luty]

I'm trying to close a form if there's no underlying data in the table. My
code:

Private Sub Form_Dirty(Cancel As Integer)
If IsNull(Me.Old_Check) = True Then DoCmd.Close
End Sub

Not working - please help!!

Thanks

 

[Allen Browne]

If you want to block the form from loading when there are no records, cancel
its Open event:

Private Sub Form_Open(Cancel As Integer)
If Me.RecordsetClone.RecordCount = 0 Then
Cancel = True
MsgBox "no body home."
End If
End Sub

 

[Lynn Trapp]

Why do you want to close a form if there is no data in the table it is
based on? How will you ever get data in the table?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Susan Luty]

Thank you SOOO much Allen......I could kiss you. Perfect!!!