i made a search form with 4 unboud search-boxes (company, first name, last name, city) and 2 buttons : clear fields and search contact
i set the deffaultvalue for every search-box to ""
then for the clear fields button i used:
Private Sub clear_fields_Click()
Me.company.Value = ""
Me.fname.Value = ""
Me.lname.Value = ""
Me.city.Value = ""
End Sub
and for the searchcontact button i used:
Private Sub search_Click()
DoCmd.OpenQuery "contacts extended2", acViewNormal
End Sub
then in the contacts extended2 query i set the criteria for the compaby, fname, lname and city field to this:
Like [forms]![Frmsearchcontacts].[*search-box name*] & "*"
i dont know what i did do wrong?
can anyone help me with this please?
regards,
Sam