Searching ALL fields in a drop down from ONE Combo box

GoodyGoody

Registered User.
Local time
Today, 09:01
Joined
Aug 31, 2019
Messages
120
Hi,

I am adding runners to a race timing database to 'register' the runner's details for the race. I am using a standard Combo box on the runners' table. So of course if I enter text it filters and then hopefully finds the runner I am looking for. now sometimes I have the runner's number not their name but rather than having a separate Combo box where you search for number I was wondering if there is a clever way of being able to search ALL the columns in the Combo box and not just the main one? So, whatever I type in the combo box it would search all the columns and return just those rows which match the data entered. I did find this link https://nolongerset.com/wecombolookup/ but it all looks very complicated so I was wondering if there was a neater, simpler way.

Thanks
Stephen
 

Users who are viewing this thread

Back
Top Bottom