Query 4 fields associated with identical drop down lists

[PolarBear]

I have (4) fields in Table1 that are associated with identical drop down lists. The query needs to search all for (4) fields for (1) specific result. The data in each field will be unique. So only one of the (4) fields for example would deliver the result "M".I would typically set up a form for use to enter the criteria and then generate a report.

One option is to set p a form that selects a criteria and then have that criteria populate all (4) fields in the query. Is this the best option?

Example:

Code
Field1 A
Field2 L
Field3 M
Field4 C

So, I need to be able to search all (4) fields and find the result "M"

Any assistance as to how best to accomplish this would be greatly appreciated.

Regards,

PolarBear

 

[JamesMcS]

Hi - I would prbably do this with a Search button and just have the follwing code therein:

if combo1.value="M" or combo2.value="M" or combo3.value="M" or combo4.value="M" then
Msgbox "M found"
Else
Msgbox "M Not Found"
Endif