Hi,
I am looking to be able to use a button in my form to open a report based on the current record in the form.
I have looked around and seen many responses for similar questions however these are based on just a single form/report. Whereas in my scenario, I have subforms and subreports all involved.
The way in which the button works with only one report is for example:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName", acViewPreview, , "[RecordID] = " & [RecordID]
Basically, I need to be able to make the ID on the subreports equal the current ID on the form. So instead of having just one report equal to the record ID, I need;
[subreport1].[recordID]=[recordID]
[subreport2].[recordID]=[recordID]
[subreport3].[recordID]=[recordID]
[subreport4].[recordID]=[recordID]
Really, I need some help being able to incorporate this into the code.
Many thanks in advance,
Kyle