Combo Box defaults to last value entered...in ALL records

[SundanceSyd]

Access 2003 - Simple Combo Box with 8-10 entries. Whatever I select to
update a record is updating all records in the file. In other words,
whatever I select from the list populates that field in all existing records,
changing what was there before. If I select a different list element, then
all the records are populated with THAT selection. Help please! Thanks!

 

[Wayne-I-M]

Hi

It sounds like an unbound combo on your form. You need to either requery
the combo when you go to a record or store the data selected in the record in
the table the form is based on.

Hope this helps

 

[John W. Vinson]

Access 2003 - Simple Combo Box with 8-10 entries. Whatever I select to
update a record is updating all records in the file. In other words,
whatever I select from the list populates that field in all existing records,
changing what was there before. If I select a different list element, then
all the records are populated with THAT selection. Help please! Thanks!

What's the Control Source of the combo box? I suspect what's happening is that
nothing is being updated in ANY table, and that you have an Unbound combo box
which is just being displayed on the form, and not stored anywhere.

John W. Vinson [MVP]

 

[SundanceSyd]

Hi,

Thank you, Wayne. Yes, I needed to store the data in the table in the form
and I had forgotten how to do that. It's been a long while since I used
Access, and I learned on an older version. Your answer opened my eyes, so
thanks!

Regards,
SundanceSyd

 

[SundanceSyd]

Hi John,

I guess it was the Control Source that I was having trouble with. I tried a
number of field names and the light came on when I selected an existing field
in the table which then populated correctly. I missed the step of adding the
field I was trying to populate to my table. When you wrote "just being
displayed on the form" I finally woke up. It's been too long since I used
Access, I guess! Thanks so much!

Regards,
SundanceSyd