Combo Box Bound Data Question

  • Thread starter Thread starter bwilcox
  • Start date Start date
B

bwilcox

I have successfully set up variable data Combo Box via VBA
with a Row Source Type of Table/Query which then uses a
Row Source SQL command to display possible selections from
a separate different table. As mentioned, it works fine.
Here's the question. How do I view and possible re-select
recorded data from the Combo Box where I entered the
data? In other words, I make a selection via a Combo Box
from Table A, record data in table B and now wish to view
the bound data from table B in the same Combo Box where I
selected the original data. Any suggestions?
 
bwilcox said:
I have successfully set up variable data Combo Box via VBA
with a Row Source Type of Table/Query which then uses a
Row Source SQL command to display possible selections from
a separate different table. As mentioned, it works fine.
Here's the question. How do I view and possible re-select
recorded data from the Combo Box where I entered the
data? In other words, I make a selection via a Combo Box
from Table A, record data in table B and now wish to view
the bound data from table B in the same Combo Box where I
selected the original data. Any suggestions?
Click to expand...

I don't understand the question. The normal way ComboBoxes work is that what you see
in the dropdown list is the data from the lookup source table and what you see when
the list is not dropped down is the data from the bound field of the form's
RecordSet. Unless you are using a multi-column ComboBox that stores one value while
displaying another. Is that what you have?
 
-----Original Message-----


I don't understand the question. The normal way
Click to expand...
ComboBoxes work is that what you see
in the dropdown list is the data from the lookup source table and what you see when
the list is not dropped down is the data from the bound field of the form's
RecordSet. Unless you are using a multi-column ComboBox that stores one value while
displaying another. Is that what you have?


.
Click to expand...
No, I am not using a multi-column ComboBox. Based upon
your answer, it is the bound data that I am not seeing.
When I scroll through the records, the ComboBox display is
blank even though data is in each field. I guess my
question is what should I check for to see the bound data?
 
Back
Top