Runtime Printing Problem

[johnb]

Hi all
I have an Access2002 db with a Form and Subform in a one-to-many
relationship. In addition I have a report base on a query which has 2
parameters which in turn point to the form and subform. On the subform I have
a cmd button to trigger the report to run. In Access 2002 full version it
works fine in Runtime version it prints the report less data.

Anyone met this before or know what the cause is?

TIA
Regards
johnb

 

[Boyd Trimmell aka Hi Tech Coach via AccessMonster.]

It would really help if you would post the code your are usong to open the
report.

 

[johnb]

Hi Boyd

The code is standard stuff eg...

Private Sub Print_Current_Record_Click()

On Error GoTo Err_Print_Current_Record_Click
'Forms!frm_CPS_Details_mgt.frm!subtotal1.SetFocus

Dim stDocName As String

stDocName = "rpt_Header_and_Parts"
DoCmd.OpenReport stDocName, acPreview

Exit_Print_Current_Record_Click:
Exit Sub

Err_Print_Current_Record_Click:
MsgBox Err.Description
Resume Exit_Print_Current_Record_Click

End Sub

The underlying Query is a Select query based on a table and child table
linked by a long int PK and FK.

The cmd button that triggers the report is located on the Form associated
with child table.

Hope this helps
John