I am using MS Access as a front end to a MySQL server on a windows platform.
The problem is that when I add a new record to a list (continuous form) of
records as soon as the cursor moves to another record the just entered data
appears as #DELETED until I requery the form. The problem is that the record
does not appear to get an ID until it is requeried so I cannot find the ID
and then return to the record after it has been requeried. I need to do this
because after creating a new record I want to open another form and insert
the new ID into it.
I have a timestamp field on the form.
Can anyone suggest a solution please.
Alex