I have a combobox on a main form. The main form does not have a record source. The record source of the combobox is a table.
I have a subform on the main form. The subform's record source is a table (different from the one tied to the combobox). I have a textbox in the header area of the subform. I want to set its value to whatever the combobox's value is. If the combobox value changes, I want the textbox value on the subform to change.