combo box populating data accross all records in database

[pamela]

I have created a database, forms etc on Access 2000. the
combo boxes are working on the form correctly however when
I subsequently open a new record, the data chosen from the
combo boxes in the previous record is now in the data
field of the new record. I have tried to set the defaults
but obviously i am not doing it correctly. Help!

 

[Rick Brandt]

I have created a database, forms etc on Access 2000. the
combo boxes are working on the form correctly however when
I subsequently open a new record, the data chosen from the
combo boxes in the previous record is now in the data
field of the new record. I have tried to set the defaults
but obviously i am not doing it correctly. Help!

Is the ComboBox unbound? Unbound controls will not reset or change record to record
unless you include some code in the Current event of the form to make it happen.
Essentially unbound controls don't "care" about what is going on with your records.
They are just sitting there until the user (or the program) does something with them.