Hi all,

I have created a form with a tab strip.

This form has a lot of controls: textbox, listboxes, checkboxes and comboboxes.

I use an ado connection to get the data from the database and initialise the form.

But what i want is to keep the data on the screen consistent with the database without a save button.

Is it a good idea to update the database on each validate event of a text box or is this too much overhead.

On the other controls i can use the click event but I do not know if this is a good way to go about this.

All suggestions are welcome.

Greetz.

Tom.

Most of the impact on performance will depend on the type of DB you use (Acces vs SQL - big difference in what they can handle), and whether the app is a desktop app or multi-user. If it´s a desktop app, you can probably take the chance to update every time the user changes data. However, I would reccommend that you build a class module that can handle the data and then save it all at once to the DB (unless there's a very good reason not to do this), in any event, if you want to synchronize the data for other users to see it, it will be hard, since you would still be locking the record while writing to it, thus preventing other users from reading its updated contents. The class solution is much better, I think, since you can provide the user with a "Cancel" option in case they wish to do so, otherwise, you've already lost the original data.