Access, Forms and MySql

I am doing some experimenting with using MS Access 2000 as a front end to a mysql db. I have successfully setup the odbc connection to mysql and the access db. I have also successfully setup a form for one of the mysql tables as follows:

awards_tbl

id - int - autoincrement
award - varchar(128)
awardDetails - varchar(TEXT)
client - varchar(128)
time - timestamp

Now, when I run the form, I can see all my previously saved records, but when I add a new record, all the fields on the form have a #deleted# value in them. I then go to the mysql db and look at the records in the awards_tbl and the new record is there with the data that I typed in. I then go back to the form and now the new record displays correctly. Is there something that needs to be done to the form to get rid of the #deleted#? Also, what other things should I look out for.

Ed Cohen

Hi Ed Cohen, I migrated MS Access 2007 database to MySQL. I have a form that I can insert, update, and delete data in Access database. But now i want to use the same form so that i can insert and update data in MySQL. It is same thing that you did. So will you please give me the steps what else i need to do so that i can connect MS Access form and MySQL. All of your help will be greatly appriciated and need to work on this as soon as possible.
Thanks,
bimi