Fields as Headers

[John M]

I know that you can make a cross tab query and get the fields as headers but
it makes the form or datasheet unusable, ie cant add any data in the
resulting fields. Is there a way of making a table with fields, from another
table, that can then be used as headers so you can use the resulting fields
for data entry. I only need this for forward planning and the data entered
would be changed regularly, but not continually added to. I also would like
to be able to change the headers occassionly without having to go behind the
scenes, so to speak, to do that. ie from the users perspective.
Hope can understand what i am alluding to here!
Thanks for any help.

[S. van Beek]

You can do change the header of the fields by changing the Caption op the
field.

If you using the caption of a field as header text, you can change the
caption in the report.

In the report you have to write VBA code under the event "By printing".

There you have to open a table and some coding to change the caption.

Example

me.Field_x.caption = Rst1.Field_x

The content of Field_x from record set 1 will be placed in the caption of
Fieled_x from the printed table.

I hope this will help you little.

Regards,

Simon
"John M" <jo*****@bigpond.com> schreef in bericht
news:xx**************@news-server.bigpond.net.au...

I know that you can make a cross tab query and get the fields as headers but it makes the form or datasheet unusable, ie cant add any data in the
resulting fields. Is there a way of making a table with fields, from another table, that can then be used as headers so you can use the resulting fields for data entry. I only need this for forward planning and the data entered
would be changed regularly, but not continually added to. I also would like to be able to change the headers occassionly without having to go behind the scenes, so to speak, to do that. ie from the users perspective.
Hope can understand what i am alluding to here!
Thanks for any help.