Change form field upon recordsource change

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

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?
 
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?
Click to expand...

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.
 
I figured it out, pretty simple really.

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