I have a single form, bound to a table, to which I can add a new record.
Once all the required fields have been completed the record is automatically saved.
I have tried saving by me.dirty = false and DoCmd.RunCommand acCmdSaveRecord.
Checking if the record is still flagged as new results in negative.
If I now click the new record button I get error 2105,"you can't go to the specified record.
If I move off the current record and back I can then create a new record.
I have also tried me.requery but that takes me back to the first record.
While going off the current record and back works, it is messy.
What am I missing?
Once all the required fields have been completed the record is automatically saved.
I have tried saving by me.dirty = false and DoCmd.RunCommand acCmdSaveRecord.
Checking if the record is still flagged as new results in negative.
If I now click the new record button I get error 2105,"you can't go to the specified record.
If I move off the current record and back I can then create a new record.
I have also tried me.requery but that takes me back to the first record.
While going off the current record and back works, it is messy.
What am I missing?