help adding parameter to a filter

fipp

Registered User.
Local time
Yesterday, 17:19
Joined
Jun 7, 2007
Messages
14
I have gotten the following to work with the 2 parameters.

DoCmd.OpenForm "reportfiltergameentryfrm", , , "opponent in (" &
Me.opponentselected & ") AND season = " & Me.cboseason

I am trying to add the following to the parameter?
[team]=Me.lstteam

[team] and [lstteam] are both text fields. only 1
possible variable. the result of [lstteam]
[lstteam] is a list box.
 
Can you show me how I would add that Wazz?

Sorry Wazz, I am a novice to a lot of this. Is there any way you can add it to the code in the original post so I can see how I should do the whole thing?

Thanks so much for your help!
 
assuming the first part works for you, i meant this:
AND [team]=Me.lstteam.itemselected

- if you just say me.lstteam you are only refering to the listbox control, not the contents
- look up itemselected in vba help for review and other ideas, or post back if this is not what you are after.
 

Users who are viewing this thread

Back
Top Bottom