Im VERY new to this, I have set up a query for a customer search:
First Name
Last Name
Pet Name
Phone Number
All of the search fields work except the phone number. There is an input mask in both the table and form, however the search wont bring up the number/customer when its ran.
Code Used:
Is Null Or Like "*" & [Forms]![SearchForm]![PrimaryNumber] & "*"
First Name
Last Name
Pet Name
Phone Number
All of the search fields work except the phone number. There is an input mask in both the table and form, however the search wont bring up the number/customer when its ran.
Code Used:
Is Null Or Like "*" & [Forms]![SearchForm]![PrimaryNumber] & "*"
Comment