Hi,
I created a form to create a brand new record. The form has 2 subforms in it and until now it has been behaving. The database has been in use for about 4 years without problems. I regularly compact and repair the database.
The form is opened (in add mode) via a button on another form (which is used as a menu).
The primary key fields are autonumbers.
The form has been working well until recently. Now when I click the button to open the form in add mode, the subforms are blank (great); but the parent form is populated with an existing ID and doesn't say (New) as it would usually. When I see this, I close the form and as you would expect, I have to abandon the data as I can't overwrite an existing ID.
I have no idea why this has started happening. I have 2 forms like this and they've both taken on this behaviour. Have I missed something in a software update that could be causing this or could something else have happened to the data?
if anyone has any ideas I'd be grateful.
Many thanks.
I created a form to create a brand new record. The form has 2 subforms in it and until now it has been behaving. The database has been in use for about 4 years without problems. I regularly compact and repair the database.
The form is opened (in add mode) via a button on another form (which is used as a menu).
The primary key fields are autonumbers.
The form has been working well until recently. Now when I click the button to open the form in add mode, the subforms are blank (great); but the parent form is populated with an existing ID and doesn't say (New) as it would usually. When I see this, I close the form and as you would expect, I have to abandon the data as I can't overwrite an existing ID.
I have no idea why this has started happening. I have 2 forms like this and they've both taken on this behaviour. Have I missed something in a software update that could be causing this or could something else have happened to the data?
if anyone has any ideas I'd be grateful.
Many thanks.