Form Changes Underlying Table

[Kmac]

Ive created a form from a table in access and when i use the form, the first
entry in the table always changes automatically. I change it back to its
correct entry and when i go back into the form and switch back to the table,
it has changed again. Can anyone give any suggestions on how to keep the
table from changing its entries, when im using a form and not wanting to
change any original entries in the table?
Thanks for any help!

 

[Wayne-I-M]

Do you have anything OnLoad OnOpen OnActivate etc etc. This would alter the
1st record if the form opens on that

Just an idea

 

[John W. Vinson]

Ive created a form from a table in access and when i use the form, the first
entry in the table always changes automatically. I change it back to its
correct entry and when i go back into the form and switch back to the table,
it has changed again. Can anyone give any suggestions on how to keep the
table from changing its entries, when im using a form and not wanting to
change any original entries in the table?
Thanks for any help!

One way this can happen is if you have one or more Combo Boxes on the form
which are used to select which record you want to view. Such combo boxes must
be UNBOUND - i.e. have nothing in their Control Source properties. If you use
bound combo boxes you'll not only move to the selected record but also
overwrite the value in the first record.