undo changes vba / sql

[Bernie]

Dear All

I use mainform and several varforms linked to sql express via ODBC. Upon
changing data in any of the forms (main & varforms), I want to prompt the
user to either discard or save changes. me.undo works per form but I don't
want the user to acquit changes per varform (I use one mainform and up to 10
varforms). I could copy sql data into local mdb file but this triggers too
much traffic and slows down the system.

How do I go about this? Would adodb 'underlying / old values' be an approach?

 

[Alex Dybenko]

Hi,
you can copy only one main form record + related records into MDB tables,
open form on these local tables, and when user commit changes - save them to
SQL server.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com