Combo Box

[Bill]

Hi,

I try to make two groups of combo to select a same report. I have a field
that contains Football, Hockey, Baseball, Tennis, Soccer.

Combo box:
1) Specific Item: "Football"
2) Other Sports: "Hockey, Baseball,Tennis,Soccer"

Combo #1 selection:
filter "Football" only

Combo #2 selection:
filter "Hockey, baseball, Tennis, Soccer" only

I don't have any problem selecting Combo #1 but I select Combo #2 and got
the result with no report.

The code that I set >> StrSports = "='" & Me.cboSport.Value & "'"

I would need your help and it would be much appreciated.
Thanks

 

[Ken Snell [MVP]]

You need to tell us some additional information.

What is the Row Source that you're using for the second combo box? or is it
a value list? Is just one value (Hockey, baseball, etc.) being stored in
each record for whichever field you're using? What is the table structure?
What is the report's recordsource?