D
David Grant
I have a text box in the detail section of a form, whose control source is a
hidden combo-box that queries a table not included in the form's record
source. It queries that table using the primary key from the form's record
set which is linked to that table.
Requerying cboHidden requeries ALL instances of cboHidden, and then the text
box for ALL records updates to an identical value, I assume because
cboHidden refers to every instance of it on the form, not just the one
specific to that record. How do I change the behavior such that these behave
locally to that record?
Thanks,
David
hidden combo-box that queries a table not included in the form's record
source. It queries that table using the primary key from the form's record
set which is linked to that table.
Requerying cboHidden requeries ALL instances of cboHidden, and then the text
box for ALL records updates to an identical value, I assume because
cboHidden refers to every instance of it on the form, not just the one
specific to that record. How do I change the behavior such that these behave
locally to that record?
Thanks,
David