Subform moves to a different Record

[Dale Howard]

Hello,

I am currently upgrading a microsoft database to use a mysql backend. The whole database was working perfectly before the upgrade.

I have created a form with a subform within a subform. The main form shows the employees details PK = (empid). The subform shows the dates the person has worked PK = SPID. The sub-subform shows the minutes that person has worked on any given day for each of the sections the person has worked PK = SectionID.

Whenever i enter data on a row in the sub-sub form, on pressing enter to commit the row and move to the next row, the data is changing to show a different row. (ie a different row, to the one that has just been entered.) Oddly enough it does show the same row each time for all employees. I have checked that the child and master id's are set correctly for all subforms.

I have tried allsorts, even tried creating the form again.

I am using Access 2003, ODBC driver 5.1.

Please help.