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?
 

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

Sum if statement - Queries 2
CBO List 1
Need Help with Parameters 1
unhide Rows when question is answered via a drop down box. 1
Group Summary 2
Create Variable Length String Dependent Upon Size List 1
Enum and Database question 2
duplicate - Group By 3

Back
Top