referencing form control in a report

[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.

 

[Allen Browne]

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.)

 

[newt]

I'll try it - 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.)

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

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

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.