Combo Box

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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?
 
Back
Top