choose which report to run based on the record

[manwe_sulimo]

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:

Private Sub OpenMRep_Click()
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "reportname", acViewPreview, , "[equipmentID] = " & equipmentID]
End Sub

[pbaldy]

If the report name is in a textbox:

DoCmd.OpenReport Me.TextboxName, acViewPreview, , "[equipmentID] = " & equipmentID]

[manwe_sulimo]

i tried to do it with combobox, but the report names are changed based on the record and i need that the user will be able to choose just the reports that allow for this specific recored.

[pbaldy]

The same method will work with a combo.

[manwe_sulimo]

The same method will work with a combo.

work like a magic.
thank you

[pbaldy]

Happy to help!

[Rivanni]

Delete the last square bracket in your code.