variables for control sources

[Guest]

Is it possible to use a variable for a control source in a report so as i can
use a table to indicate what the field shows in my reports? if so please
tell me how

 

[Alessandro Baraldi]

Mike ha scritto:

Is it possible to use a variable for a control source in a report so as i can
use a table to indicate what the field shows in my reports? if so please
tell me how

You mean RecordSource...?

On OpenEvent you can change the source like you need.
The String can arrive from a Variable or from a Table no problem at
all...!

Me.Recordsource=GlobalStringVarSource

Also passing the Source ina Args parameter(min.. version AXP):
Me.RecordSource=Me.OpenArgs

@Alex

 

[Guest]

No I need to be able to change the fields. For example my report shows a
budget for a 5 year period. I want a form that will let me enter what 5
years will be displayed. The report is linked to a crosstab query. What I
need the report to look like is

Budget Line Year 1 Year 2 Year 3 Year 4 Year 5
Sample value value value value value
sample 1 value value value value value

Year 1 through 5 would be selected from the form. I guess what I mean is I
need a way to enter what i want the column headers to be

Can this be done