Bill Schneider wrote:
I have rebuilt a govermental formular with a report by putting some 30
textboxes in the page header at the right places for printing. I want
to fill these textboxes with the data from a query, putting each item
of each record into the right textbox.
But I do not find out how to do this.
Could please someone give me a hint. Is it possible at least and what
is the correct syntax and where to put the code.
I'm missing a cardinality indication in your question. No, let me state
this in normal language. You have one page header, but many (how many?)
records in the query; how do you wish to see this in the report?
You can always put "random" values from data sources, be it queries or
tables, into a control with the DLookup function, or other members of
that family; but the 'each record' clause in your question hints me that
that is not the approach here.
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea