Reference Fields in Print_Event Procedure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report called "Print Order" that has as it's Record Source a table
called "Order". I don't want to print all of the fields in the table order
but I need to access all of them in the Print_Event procedure. Therefore my
question is how do I reference fields in the underlying table "Order" , if
they are not bound to controls on the report. Do I need to open a recordset
on the table "Order" ?
 
Chippy said:
I have a report called "Print Order" that has as it's Record Source a
table called "Order". I don't want to print all of the fields in the
table order but I need to access all of them in the Print_Event
procedure. Therefore my question is how do I reference fields in the
underlying table "Order" , if they are not bound to controls on the
report. Do I need to open a recordset on the table "Order" ?
Click to expand...

Add hidden TextBoxes bound to those fields. Otherwise you won't be able to
access them in your code. This is a peculiar behavior of Access reports.
 
Back
Top