set textbox controlsource dynamically?

[supmktg]

I have a report based on a table. The report has room for 6 columns. There are 12 fields in the table, from which 6 are selected for the report. I can change the column header labels dynamically in the OnFormat event of the Page Header, but I am unable to change the conrolsource of the textboxes in the detail section to match the column headers. I get a "Run-time Error '2191' You can't set the control source property after printing has started."

What is the proper way to accomplish what I am trying to do?

Thanks,
Sup

 

[tkaplan]

see the following link for dynamic crosstab reports. I believe you can use the same method for changing your textboxes and labels.

http://support.microsoft.com/default...;en-us;Q328320

 

[supmktg]

T,

Wow! I had given up thinking it was impossible. I have changed my report record source to a query with a bunch of nested if statements. It's very ugly!

As soon as I have a chance I'm going to try the method in Microsoft article Q328320. It looks like exactly what I was looking for.

Thanks,
Sup

 

[tkaplan]

glad to be of service
please let me know how it goes...