Dynamically modify form fields using VBA based on form user-input

I am attempting to reuse a basic report by dynamically modifying it using user inputted values from a form.
This eliminates the need to create multiple reports that vary only slightly for a single column.

I have a form that asks the user which report type to run (using radiobuttons).  The user selects a report type and then clicks a button to open the report.

The report layout will be exactly the same for all report types EXCEPT the "type" column will vary based on their form selection.

The report layout has columns for FiscalYear, AdviceNumber, AdviceDate, [ColumnX]...
ColumnX is the column that will change based on the form input and will be an AdviceType (e.g. MandI, TribalEquipment,  Replacement, etc.) containing a dollar value.

I have the logic built so that the form button runs VBA to add data to a temporary table.  It 1st deletes all data from the table and then inserts the data appropriately based on the user selection (e.g. if they select Replacement as the type, then only replacement data is added to the table (even though the table has columns for the other types, but they are just set to 0).

Then, the Reports recordsouce points to this temporary table so it never needs to change.

The Dilemma...
I need to be able to to dynamically change the Label.name And textbox.datasource based on the user selection.

I tried the report's OnOpen event to do this, but I got an error saying this can only be changed in Design view.

Any suggesstions??
Start Free Trial