halo all,
background - i have a form that show record from a table based on the user choice, and the form also return for each record (based on another table connect to the first table) which report are allowed for this record.
i need the user to choose which report to print from a list, and the programm to print the right report with the data from the right record that open on the form.
so far, i have managed to print the right record on the report based on the active record, but i failed to made the right report run based on active record on subform.
thx
so far i made this:
Code:
Private Sub OpenMRep_Click()
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "reportname", acViewPreview, , "[equipmentID] = " & equipmentID]
End Sub