B
Bob Quintal
tryI have the following command that works perfectly.
docmd.openform "MyForm1",,,"opponent in (" &
Me.opponentselected & ")"
I am now trying to add 2 more criteria to the filter when I
open the form. I can't quite get the code right.
(maingameformation.season)= Me.cboseason
(maingameformation.team)=Me.cboteam
"opponent in (" & Me.opponentselected & _
") AND maingameformation.season =" & Me.cboseason _
"maingameformation.team =""" & me.cboteam & """"
This assumes that the table field type for season is number and
for team is text.