ADO w/ MYSQL - Bound controls not updating db

[BrendanK]

Hi there,

hope someone can help me.

I'm building a VB app which interfaces with a MYSQL Db using ADO... So far things have been sweet - I've had good speeds and for reading data, the functionality through ODBC has been fine.

One form in my app however has a bunch of controls bound to an ADO data control. I found that if I changed the value of a field then unloaded the form, the control would not save the data, so I had to force an .update before exiting.

I now have a really funny glitch, where my textboxes wont change the database unless you delete the contents first then type the new value.

??? help!!

Cheers

Brendan