Hello again,
I am in need of more help.
This time, I have categories with the name of "Customer ID" , "First Name" , "Last Name" , "Age" , "Date Of Birth" , "E-Mail Address" , "Yearly Income", and "City".
I am trying to make a search bar, (From a text box named "txtSearchCustomers") and then click a button to actually search. (The button on click event is where I am placing this code.
These are the 2 types of code I tried.
Code:
Me.Filter = "[Customer ID] = " + Chr(34) + Me.txtSearchCustomers + Chr(34) Me.Filter = "[First Name] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
Me.Filter = "[Last Name] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
Me.Filter = "[Age] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
Me.Filter = "[Date Of Birth] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
Me.Filter = "[E-Mail Address] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
Me.Filter = "[Yearly Income] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
Me.Filter = "[City] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
Me.FilterOn = True
and
Code:
Me.Filter = "[Customer ID] OR [First Name] OR [Last Name] OR [Age] OR [Date of Birth] OR [E-Mail Address] OR [Yearly Income] OR [City]" + Chr(34) + Me.txtSearchCustomers + Chr(34)
Me.FilterOn = True
Any help is appreciated.