Hi
I'm using MS Access as a front end program, and I have a form based on a query which obtains the data from a MySql database on a server.
My problem is that I try to make a simple button which I wrote VBA code with a simple command like field.setfocus and field.text=whatever to insert some data into that field. At that point I dont have any problems. The warning message appears when I try to change into another subform, then the little window pops up and says: The record has been changed by another user since you started editing it...etc. ...and I am the only user
I would really appreciate some help on this one.