hi all
i have recently migrated my BE Db to a MySQL server, for the most part its stabel a few loading issues which i have resolved, however i seem to have come across a problem i cannot see a resolution to
i have a form called FrmManHoursAdd
in this form i have a subform called SubFrmManHoursAdd
these are linked with a master and child field, when i use the FE with a BE Db on my laptop it works no problems, but when im linked to the MySQL server, the Sub Form does not load.
when i go from form veiw to design view and back to form view, the sub form loads, with all entries, so it is working to some extent.
i have tried on the main form
but it did nothing.
any help would be very appreciated
i have recently migrated my BE Db to a MySQL server, for the most part its stabel a few loading issues which i have resolved, however i seem to have come across a problem i cannot see a resolution to
i have a form called FrmManHoursAdd
in this form i have a subform called SubFrmManHoursAdd
these are linked with a master and child field, when i use the FE with a BE Db on my laptop it works no problems, but when im linked to the MySQL server, the Sub Form does not load.
when i go from form veiw to design view and back to form view, the sub form loads, with all entries, so it is working to some extent.
i have tried on the main form
Code:
_OnCurrent Me.SubFrmManHoursAdd.Form.requery
any help would be very appreciated