referencing form control in a report

  • Thread starter Thread starter newt
  • Start date Start date
N

newt

I am using a form to supply a parameter to a report. The query that is the
source for the list box on the form selects four fields from a table. The
*first* field is the bound column (i.e., it is the variable on which the
filter is based), but I want to display the *fourth* field in the header of
the report.

As always, any help is greatly appreciated! Thanks.
 
Try this kind of thing:
=[Forms].[Form1].[List99].Column(3)

The first column is number zero, so Column(3) is the 4th one.

(Not sure if this will work in all versions of Access.)
 
I'll try it - thanks!

Allen Browne said:
Try this kind of thing:
=[Forms].[Form1].[List99].Column(3)

The first column is number zero, so Column(3) is the 4th one.

(Not sure if this will work in all versions of Access.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

newt said:
I am using a form to supply a parameter to a report. The query that
is the source for the list box on the form selects four fields from a
table.
The *first* field is the bound column (i.e., it is the variable on which
the
filter is based), but I want to display the *fourth* field in the header
of
the report.

As always, any help is greatly appreciated! Thanks.
Click to expand...
Click to expand...
 
Back
Top