Searching ALL fields in a drop down from ONE Combo box (1 Viewer)

[GoodyGoody]

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

 

[jdraw]

Your term "..Search all columns...." reminded me of an old post (Modified universal search). It may not be exactly what you're asking, but may be adaptable.

 

[GoodyGoody]

Your term "..Search all columns...." reminded me of an old post (Modified universal search). It may not be exactly what you're asking, but may be adaptable.

Thanks. I'll check it out

 

[arnelgp]

here is a sample, it will search either in [Last name] or [first name]

 

[GoodyGoody]

here is a sample, it will search either in [Last name] or [first name]

Thanks