Pull-down Menu -




I need your help and I hope I did the right thing.

I want to select "Hockey" to pick up the list (Hockey A to D).


Hockey A
Hockey B
Hockey C
Hockey D

I was not able to pull the list of all hockey from A to D. I tried to create "like" but it did not work. I am appreciated your help.

Thanks again.

Here is what I wrote:

strSPORTS = "Like " & Chr(34) & Me.cbo_SPORTS.Value & "*" & Chr(34) & ""

strFilter = "[Year] " & strYear & " and [City] " & strCity & " AND [SPORTS] " & strSPORTS_
& " And ([Planning] is null)" _
& " and ([GAME_DATE] In(" & strGame_Date & "))"

stDocName = Me!Reports
DoCmd.OpenReport stDocName, acPreview, , strFilter



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

Pull Down Menu 2
Pull Down Menu 1
Pull Downs 21
pull down 2
pull down 1
calculated field referencing a pull down menu 1
creating a combo box with a pull-down menu 3
creating pull down menu in a form in Access 5