Greetings. I'm in a bit of a pickle since I have two different "customers" (with somewhat similar databases) who want their respective databases by the end of the year.

Here's what I have - seven tabbed subforms, some of which have multiple entries and others which have none. Whatever the tabbed subform, if there are multiple entries, only the first record entered prints out (all of the records exist in their respective tables).

What do I need to do to have the multiple entries print out? All assistance is greately appreciated.


TIA,

AvgJoe

Joe, I use this in th OnClick event of a cmdButton:
Dim stDocName as String
stDocName = "ReportName"
DoCmd.OpenReport stDocName, acNormal, , "[Pkey] =" & Me.Pkey
Do the appropriate substiutions and I hope it works as well for you as it does for me. hth.
PS: this print out sometimes as many as a dozen records which are in the subform.

Edited by: quest4 on Fri Nov 19 16:37:40 EST 2004.