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.