Drop Down Boxes

[Guest]

I created a drop down box with values that will never change, but when I go
to the record to use it, it changes the field on all records not just the one
I am working on. How can I stop it from doing that? I need to be able to
change the records individually.

 

[Arvin Meyer [MVP]]

Your combo box is unbound to the underlying table. No records are being
changed. You need to bind the ControlSource property to a field in the
underlying table or query. Open the form in Design View, select the combo,
Open the property sheet (View >>> Properties) and go to the Data tab. Select
the underlying field.