Clear button on form not wroking properly

[gojets1721]

I've got a form that I use to filter a report. I have clear button so that the user can press it and it resets the fields to remove all the info in there in order to do a new search. The button clears the fields fine, however after you clear it, input new content into the fields and search, the report comes back completely empty. Not sure what is wrong. The 'clear button' code is below:

Private Sub btnClearForm_Click()
    Me.txtStartDate.Value = ""
    Me.txtEndDate.Value = ""
    Me.txtCustomerID.Value = ""
    Me.txtEmployee.Value = ""
    Me.ComboLocation.Value = ""
    Me.ComboCategory.Value = ""
    Me.ComboSubCategory.Value = ""
    Me.Requery
End Sub

 

[theDBguy]

Hi. Are you using a bound form to filter a report? Can you show us the code to actually filter the report? Maybe you're clearing the form but not the report.

 

[MajP]

Also, all values should be set to null not empty strings.

 

[gojets1721]

Also, all values should be set to null not empty strings.

This worked! Thank you

 

[Pat Hartman]

Common mistake. "" is NOT the same as Null.