Can you provide exactly some code example on how I would put this into a different sub? I thought to leave it in the sub for addcmdbutton_click() because I need to update the linked table (mdb file) and mysql when this event occurs (add button clicked on).
The reason for duplicate entries is...
Need some help with linking mysql database and running a query declared in a function. Currently my access form is updating the linked table (mdb file) but need it to also update changes to mysql table. Below is the code I tried:
Dim db As DAO.Database
Dim rstAccounts As...