Browsing via combos

[aset]

I have 2 combos Batch No and Form No. Based on the selected Batch No, the possible list of Form No pop up. Now , I have enabled travering of form based on the list of values in Form No. Based on the selected form no, I pull up name, address, etc...

The problem is at the botton of the screen the access record displays 1. So when I exit the access form, it tries to save the current data on record 1, hence overwriting some of the details on the 1st record or giving an error
"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the field or fields containing duplicate data...." "

What do I have to do to correct this ? I am new to access.

best regards,
Anuj

 

[Jeanette Cunningham]

This happens when your combo box is bound to one of the fields in the form.
Combo boxes for searching need to have nothing in their control source - we call that an unbound combo.
So delete the control source for the combo and see if that fixes the error.