I am using a ListBox to capture multiple column values. I use SetTempVar to hold the desired values and
Open a Report query that depends on these values. I was expecting that the report would have access to the TempVars values,
which are used in the WHERE Clause, but it doesn't look like the report has access to them.
I am using these 2 lines in VB. The first one to confirm that the values were set, and they are. And, the 2nd to
open the report. What am I doing wrong?
1. MsgBox "This was selected: " & Me.Team.Column(0) & " " & TempVars!teamID & " " & TempVars!yearID
2. DoCmd.OpenReport "Teams Record & Roster", acViewReport, , , , "TempVars!teamID, TempVars!yearID"
Thanks in Advance.