GoodyGoody
Registered User.
- Local time
- Today, 03:22
- 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
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