combo box

[Jaymcintyre]

I created a combo box with 3 choices. Each time I choose a value for one
record, the value changes to that value in all the other records. How do I
make the choice for only one record at a time?

 

[KARL DEWEY]

The combo must be bound to the field in the table.

 

[Stockwell43]

Hi Jay,

Just a few things to consider:

1. Do you have these three choices in a separate table?

2. If so, do you have your Combo Box bound to that table?

3. Is there a field name in your main table that's the same name of your
combo box?

4. When you created the combo box through the wizard, did you use the
default values?

 

[Jeff Boyce]

You don't mention where this is happening (e.g., directly in the table, via
a form, ...)

I've seen similar behavior if a datasheet view was used. If that's your
situation, consider using a continuous form and creating a single record's
controls in that form. That way, the combobox only applies to that record.

And as other responders have pointed out, leaving a control unbound tells
Access that it applies to ALL records that control appears with on the form.
Of course, since it was unbound, the underlying table will NOT reflect the
choice! Does your table show the change in all records, or is this just
appearing to happen in a form?

Regards

Jeff Boyce
Microsoft Office/Access MVP