Subform printing out blank?

[tonygg]

Hi



I have a form that displays lots of data in various list boxes and calculated fields. It is also larger than the width of 1 sheet of A4. Hence if you print it shows some of the totals on page 2 and is generally unpleasant.

I wanted to allow the user to print out a simpler summary view as a record of the work done (a financial reconciliation). As the form has many hundreds of lines of code I didn't want to duplicate it into a report.

To do this I created a subform which sits on top of the main form and on a button press on the main form it is made visible and populated with the summary data (as per the code fragment below):

.........

Form.[LUCY WORLDPAY RECON PRINTOUT]!TotalAdjustedSalesD = Me.TotalAdjustedSalesD
Form.[LUCY WORLDPAY RECON PRINTOUT]!TotalUKTaxD = Me.TotalUKTaxD
Form.[LUCY WORLDPAY RECON PRINTOUT]!TotalAdjustedShipD = Me.TotalAdjustedShipD
Form.[LUCY WORLDPAY RECON PRINTOUT]!WPAfterCommission = Me.NetTotalWorldPayD - Me.TotalMerchantCommissionD

If Me.[LUCY WORLDPAY RECON PRINTOUT].Visible = False Then
Me.[LUCY WORLDPAY RECON PRINTOUT].Visible = True

Else

Me.[LUCY WORLDPAY RECON PRINTOUT].Visible = False

End If

This all works fine and the summary data appears in the sub form correctly on the screen.

The problem I have is when I use :

DoCmd.PrintOut acPages

The Form with the subform on top is printed in the same layout as you see on the screen. However all the subform fields are blank. The fields that you can still see on the main form all have the correct values.

The happens whether the print command is issued from the main form or the sub form.

Please could someone help me to get the fields to appear on the printout?

Many thanks

tony

[June7]

Why would form code be duplicated into a report?

Forms are not intended for printing although can - I do this. However, never tried to print a form with a subform. Why can't this subform instead be a report?

[tonygg]

I guess I don't have much experience of reports.

The fields I need to print are all calculated fields based on code rather than formulae (I.e not simple to recreate). That is why I was just copying the results to the sub form using the simple access referencing parent and child relationship (please see the code example fragment in my last post). Is it possible to do the same simple referencing from a report so it picks up the calculated fields in the form when it launched? If so that's brilliant but would be grateful if you could show me how to achieve this.

Many thanks

tony

[June7]

Yes, textboxes on report can have expressions that reference form controls.

[tonygg]

Thank you for confirming this. Would it be possible to show me a simple example line of code based on the code fragment above on how to do this. Currently the code in my first post sits in the main form and copies the contents of text boxes in the main form into text boxes in the sub form. Many thanks. Tony

[June7]

Expression in textbox on report:

=Forms.mainformname.textboxname

[tonygg]

Many thanks for your help