Invoke report with DoCmd previews all records - Please help!

[tstoneami]

Hello Folks;

I use a method similar to this:

Private Sub Command175_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If


If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
Else
strWhere = "[Repetitive # or Name assigned] = """ & Me.[ Repetitive # or Name assigned] & """"
DoCmd.OpenReport "Repetitive Listing", acViewPreview, , strWhere
End If
End Sub

Where I get a loan number from a form. It actually previews the correct record as the first report, but doesn't tie the correct sub report - and proceeds to print all the records of the table associated with the sub report.

If I use an alternate DB with just a small number of records, and print them all (no docmd), they are properly associated.

I am at my wits end...do I need to also pass the parameters to the subreport?

Any help worshipped...and thanks!

[pbaldy]

Normally a subreport is kept in sync with the main report with master/child links (properties of the subreport control). If you used the wizard to add the subreport, it would have asked about linking fields. Are those appropriate?

[tstoneami]

I didn't use the wizard. Made the subreport separately and stuck it in the main report. I always saw the proper linking field in the property for master/child, and just now clicked the ... icon to see what the dialog might indicate. It gave me an error (The expression you entered refers to an object that is closed or doesn't exist.). The source object is the main report.

[tstoneami]

Correction, the source object is the name of the subreport.. The Master and child fields had previously referenced a field on the main report.

[pbaldy]

Can you post the db here?

[tstoneami]

Hey folks;

I figured this out. The subreport needs a match to the field on the main report in order to link the two via the Link Master/Child Fields. The simple fix was to put a common field on the subreport and make it invisible. It's then available in the Link Dialog. Thank you for your interest in helping me - hope this discovery helps someone else.

[pbaldy]

Glad you got it sorted out.