Access2007 Combo Box

[ALF]

Never saw this before and can't fix. I have an unbound combo box with 6
names. In the form I can choose one name. When I look at the next record it
has that name in it, the next and the next...How do I stop this? I want that
name in the current record ONLY not all of 'em.
I'm not a programmer so simple is good!
Thank you
Andrea

 

[John W. Vinson]

Never saw this before and can't fix. I have an unbound combo box with 6
names. In the form I can choose one name. When I look at the next record it
has that name in it, the next and the next...How do I stop this? I want that
name in the current record ONLY not all of 'em.
I'm not a programmer so simple is good!
Thank you
Andrea

An unbound combo box on a Continuous Form is *one combo box* - even if you see
it six or sixty times on the form.

If you want data to be associated with each record in a table, it must be *in
the table (or in a related table). A combo box on a form is not a data storage
medium.

If you want the name to be in this record and not all of them - then the combo
box MUST be bound to a field in the table.

 

[KARL DEWEY]

Because it is 'unbound' it does not reflect data from any record.

If you were to open the table you would see that the field does not contain
data.