Pull-down Menu -

L

learning_codes

Hi,

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).

PULL-DOWN MENU: Hockey

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

Unwanted Rounding Percentages 3
Weird date format problem 2
Sum if statement - Queries 3
filtering a form based on the values of a subform 0
Creating a Search using a combo box and then creating a report. 4
Create Variable Length String Dependent Upon Size List 1
automatic calculations with drop down fields 1
Is there a template to create a Hockey Pool?? 0

Top