Change form field upon recordsource change

[ryan.fitzpatrick3]

I have a form that pulls from 2 different record sources depending on
what criterion is selected when a user runs the query. my form has
headers over these fields. Is there away to change the field name if
when the record source changes and also the header label as well?

 

[Stuart McCall]

I have a form that pulls from 2 different record sources depending on
what criterion is selected when a user runs the query. my form has
headers over these fields. Is there away to change the field name if
when the record source changes and also the header label as well?

I wouldn't recommend trying to change field names at runtime. However it is
possible to change the column header text, by setting the Caption property
for a column. In query design view, click on a column, open the property
sheet and type something into the Caption property.

 

[ryan.fitzpatrick3]

I figured it out, pretty simple really.

Me.Label57.Caption = "Commodity"
Me.in_comcd_key.ControlSource = "in_comcd_key"