Runtime Printing Problem

  • Thread starter Thread starter johnb
  • Start date Start date
J

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
 
It would really help if you would post the code your are usong to open the
report.
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
Click to expand...

--
Boyd Trimmell
aka Hi Tech Coach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com
 
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
 
Back
Top