Combo Box

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
 
K

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top