Any ideas why this wont close the form if the listbox is empty?

[shabbaranks]

Hi,
As the title suggests Im trying to close a form using VBA if a listbox is empty as per

Private Sub CloseApprovalForm_Click()
If TimeApproval_lstbox.ListCount = 0 Then
DoCmd.Close acForm, "frm_TimesheetApproval", acSaveNo
End If
End Sub

It works if I comment out the If listcount bit, but I only want users to close it if its empty. Is it me being simple?

Thanks

[pbaldy]

What is the Column Heads property. If it's Yes, you probably need to test for 1.