Combo Box Bound Data Question

[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?

[Rick Brandt]

"bwilcox" <bwilcox@cme.com> wrote in message
news:01c601c34bbe$60749b70$a301280a@phx.gbl...

> 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?

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?

[bwilcox]

>-----Original Message-----
>"bwilcox" <bwilcox@cme.com> wrote in message
>news:01c601c34bbe$60749b70$a301280a@phx.gbl...

>> 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?

>
>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?
>
>
>.
>

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?