Help with Data Reports needed.

[Toby1kenobe]

Hi all

I've set up a form as a 'Report Menu' from here i want to launch my reports. I can do this but i cant get the reports/query to look at items selected on this menu. For example, User selects a name from a combo, and this student's results are displayed.

Do i just reference the controls on my form within the DataEnvironment command SQL statement?

like

select * from tbl_Main Where [Student_name] = frmReport.combo1

Thanks for any help
Toby

 

[Skittle]

If you are excuting your SQL statement as a source for a recordset and I have read your problem correctly I think this may help.

strSQL = "SELECT * FROM TBL_MAIN WHERE STUDENT_NAME = '" & _
"'" & frmReport1.combo1 & "'"

Dazed and confused