G
Guest
I have a combo box that has hidden columns that automatically fill in other
fields. Is there another way to do this so that if I update a table the
combo box selections will be updated as well?
For instance, have updated 'Table1' and now select 'abc' in my combo box in
the form. Now, the old values will appear without the updates to Table1.
This is related to an earlier post...->
I POSTED THIS EARLIER:
I am working on building a form. I have a combo box with several product
choices. When I make a selction in the combo box I would like the product
reference number and description to appear automatically in the two other
fields in the form. Thanks so much!
Here's what my table looks like
TABLE1:
Product Name Reference # Description
abc 00001 toy boy
..............
AND GOT THESE INSTURCTIONS (WHICH WORKED):
Add those as additional columns to your ComboBox (hidden if you prefer) and
then
use ControlSources for your TextBoxes of...
=ComboBoxName.Column(1)
and
=ComboBoxName.Column(2)
fields. Is there another way to do this so that if I update a table the
combo box selections will be updated as well?
For instance, have updated 'Table1' and now select 'abc' in my combo box in
the form. Now, the old values will appear without the updates to Table1.
This is related to an earlier post...->
I POSTED THIS EARLIER:
I am working on building a form. I have a combo box with several product
choices. When I make a selction in the combo box I would like the product
reference number and description to appear automatically in the two other
fields in the form. Thanks so much!
Here's what my table looks like
TABLE1:
Product Name Reference # Description
abc 00001 toy boy
..............
AND GOT THESE INSTURCTIONS (WHICH WORKED):
Add those as additional columns to your ComboBox (hidden if you prefer) and
then
use ControlSources for your TextBoxes of...
=ComboBoxName.Column(1)
and
=ComboBoxName.Column(2)