Macro - Open Report, SetValue

[NLA]

I have a report (selected from Switchboard) dependent upon a parameter query that gets its value from a form combo box [frmDocument.DFilename]. That combobox row source is a select statement for a specific table field[tblDocument.DFilename]. This report works as intended.



I would like to use the same report but run it from a different form (not the Switchboard) and get the value from the new form instead of the parameter query from the first form. I thought to accomplish this i could use SetValue to set the value [frmDocument.DFilename] = [frmMatrix.Filename] (new form textbox). This is ok, but my macro stops because i believe the value being set from new textbox to existing combobox is not being passed to the parameter query.

Is there a way to use SetTempVar to set the new form textbox [frmMatrix.Filename] value to equal the query Filename field instead of parameter query getting the value from [frmDocument.DFilename]??

Thanks for any feedback/suggestions on this.

[June7]

Don't use parameter query (I rarely do). Use the WHERE CONDITION of OpenReport. I use only VBA so not sure what the macro equivalent would be:

DoCmd.OpenReport "reportname", , , "DFilename='" & [frmMatrix.Filename] & "'"