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 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.setfocus
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.