combo box populating data accross all records in database

  • Thread starter Thread starter pamela
  • Start date Start date
P

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!
 
pamela said:
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!
Click to expand...

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