Unanswered: newly-added record appeared as #Deleted#
i use ms access connecting mysql via ODBC, the form's underlying table has an autonumber field (primary key). Most of the time (not ALL the time) when i add a new record, the form displays the newly-added record as #DELETED# for all fields on the form. But the new record was actually added to table. i have to close down the form, open it again and then move to that record to continue.
my workaround for this now is that i dont let access add the autonumber itself, i write a function to add the number instead. this works so far but i still want to know how to fix it.