Missing Records in Table - Combo Box Problem?

[Guest]

Have had same database running fine for 6+ years. With a few new users added
in past few months, suddenly encountering some problems with 1 particular
table. The table is a "source code" table containing 3 fields (unique id
auto-number, code (text field), description, and active (yes/no field). I
have a query based on this table that returns all active source codes. On 3
forms, there are combo boxes which have limit-to-list set to yes, where the
user selects the correct source code from the list. For some reason, lately
one or two of the "code" field is changing in my table. It's almost as though
someone is "overwriting" the field through the combo box. Is that possible?
Today I've also noticed that a few of the records in the table are actually
missing. Any idea on how this can be happening?

 

[UpRider]

Are the combo boxes bound to the table data fields? They should not be if
you don't want the combo boxes to update the source code table.

UpRider

 

[Guest]

I think I've found my problem. In 4 of the 5 forms that use this data, the
form had combo boxes, based on a query of the table. The 5th form actually
had this field as a text box, bound to the table. I think the field was added
as an afterthought for what was intended to be a reference only, but
apparently someone was making edits to this field which subsequently changed
the data in the table. I have set the field property to "Locked". Hopefully
this will eliminate the problem until I can come up with a better way to do
that. Thanks so much for your help!