Warning msg --> The record has been changed by another user...
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 through ODBC driver.
My problem is that I try to make a simple button which I wrote VBA code with a simple command like:
field.text = "whatever"
The idea is to insert some text into that field. At that point I dont have any problems. The warning message appears when I try to change to another record, or if I add a Me.Refresh line into that code.
I have no problem adding, editing or deleting fields. The only way this windows pops up is when I try to edit or add text to an existing field using VBA on a button.
Furthermore if I use this button on a new record it works fine, at this point if a go to the first record, it works once more, from that point on, every time I click the button the popup appears :(
...and yes I added the TIMESTAMP field on the table using CURRENT_TIMESTAMP as default.
I would really appreciate some help on this one.
|All times are GMT +5.5. The time now is 05:57.|