Hi guys,
In an application a number of forms calculate values that must be stored in new records in a number of different tables.
In these forms I always use: me.recordsource="table1"
docmd.gotorecord,,acnewrec.
Most of the times this works perfectly. However, in a specific form Access is not adding a new record, but skips to the first record in the table and overwrites the values of the fields.
It took me hours searching for an error in this form, but could not find one.
Having no idea what was wrong I decided to open a new empty form and copy all object of the other form to it as well as the coding, delete the other form and gave the new form the name and properties of the other form. To my surprise the new form worked well.
This occurred two more times with other forms, and the here mentioned solution worked there as well.
I hope there is someone who can tell me what was wrong here.
This application will be implemented on a customers pc and of course I'm wondering if the same can happen in his environment.
If that is the case it might result in loss of valuable data.
Thanks for your time,
Ad