Access2007 Combo Box

  • Thread starter Thread starter ALF
  • Start date Start date
A

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
 
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
Click to expand...

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.
 
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.
 
Back
Top