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

GoodyGoody

Registered User.
Local time
Today, 05:49
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
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:49
Joined
May 7, 2009
Messages
16,394
here is a sample, it will search either in [Last name] or [first name]
 

Attachments

  • sample combo filter as you type.accdb
    768 KB · Views: 166

Users who are viewing this thread

Top Bottom