J
Jay
I have encountered an error after adding new controls to a
form that updates a table via a recordset. What has
randomly occurred is the recordset seems to lose track or
revert back to the old table index and starts saving
information into the wrong fields. The field names are
definitely unique. Below is a basic example:
With rs
.AddNew
<<<MANY OLD FIELDS>>>
![SpecDevice] = frmc!cmbSpecDevice.value
<<<ONE OLD FIELD>>>
.Update
End With
Do I have to add new fields to the end of a table and /
or when updating a recordset?
Any ideas?
Thanks
Jay
form that updates a table via a recordset. What has
randomly occurred is the recordset seems to lose track or
revert back to the old table index and starts saving
information into the wrong fields. The field names are
definitely unique. Below is a basic example:
With rs
.AddNew
<<<MANY OLD FIELDS>>>
![SpecDevice] = frmc!cmbSpecDevice.value
<<<ONE OLD FIELD>>>
.Update
End With
Do I have to add new fields to the end of a table and /
or when updating a recordset?
Any ideas?
Thanks
Jay