Hi,
I've been searching through the forum and I've found a few helpful posts, but I'm still having trouble pulling everything together.
Here's the situation:
In a user form, a value is selected from a combo box. I then want a search to be done on a query to look for that value and filter down to all the records that contain that value. The issue is the value that what I'm looking for is located in any one of three known columns (out of about 50 columns total), and the value that is being searched for is only a partial text in the field.
For example...
I select the value "Monk" from the combo box. I then want to search three columns in the query for it but the fields containing "Monk" actually might be something like "Monk-123" or "Monk ABC".
In summary, I want to filter out all records that don't contain the partial-text "Monk" which is located in any one of those three columns.
Thank you a ton for ANY help you can give!
dkinnz
I've been searching through the forum and I've found a few helpful posts, but I'm still having trouble pulling everything together.
Here's the situation:
In a user form, a value is selected from a combo box. I then want a search to be done on a query to look for that value and filter down to all the records that contain that value. The issue is the value that what I'm looking for is located in any one of three known columns (out of about 50 columns total), and the value that is being searched for is only a partial text in the field.
For example...
I select the value "Monk" from the combo box. I then want to search three columns in the query for it but the fields containing "Monk" actually might be something like "Monk-123" or "Monk ABC".
In summary, I want to filter out all records that don't contain the partial-text "Monk" which is located in any one of those three columns.
Thank you a ton for ANY help you can give!
dkinnz