Opening report from listbox in form

[isapple]

Hi,

First of all, I have a report that runs a parameter query identifying which StudentID it wants to run the report of, and what month/year.

I want to leave the month/year as a parameter, but what I want to do is get the record that I selected from the listbox (IE. student 1000) and then when I click on Run Report Card, it wouldn't ask me for the parameter of the student, but just the year, and then it would run the report card for the student I selected.

I tried doing the
open report macro and in the where row I put
[StudentID] = [Forms]![Form1]![List12]

but it didn't seem to work.

 

[pbaldy]

If it's not multiselect, this should work:

http://www.baldyweb.com/wherecondition.htm