Search Two Fields - Search Form 2.0 in Microsoft Access


	Back to Search Form 2.0 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Search Two Fields

Matthew McHenry

4 years ago

I am trying to look up customer by phone number. In CustomerT there are PhoneNumber1 and PhoneNumber2. Is there way in VBA to search both fields just using one "search box"?

I am still in the deigning phase of my Database so I'm not against putting all the PhoneNumber in their own Table.

	Kevin Robertson @Reply 4 years ago
You could do something like this. `WhereStr = WhereStr & "PhoneNumber1 LIKE """ & txtSearch & """ OR PhoneNumber2 LIKE """ & txtSearch & """"`

	Matthew McHenry OP @Reply 4 years ago
I think I mess up " somewhere If PhoneNumberSearch <> "" Then If WhereStr <> "" Then WhereStr = WhereStr & " AND " WhereStr = WhereStr & "PhoneNumber1 LIKE """ & PhoneNumberSearch & """" Or "PhoneNumber2 Like""" & PhoneNumberSearch & """" End If

	Adam Schwanz @Reply 4 years ago
Look at what's different in yours and Kevins. You have an extra quotation in the middle. It doesn't need "*""" in the middle, it only has that extra " at the end to close the statement.

	Adam Schwanz @Reply 4 years ago
One of the most confusing things is the quotations. Just remember everytime you start with a ", you are opening a statement, and at the end of the statement you need another " to close it.

	Matthew McHenry OP @Reply 4 years ago
Fount them both the way I had it PhoneNumber2 was a txt str not a feild to be search.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Search Form 2.0.

Next Unseen

New Feature: Comment Live View