You can't use DAO with SQL Server 2005 (or any flavor). You have to use ADO if you want this to work. This will update the forms. I assume they are either not bound, or are bound to a non-updatable query.

I would process this as a separate transaction. What options and events do you have to work with?

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com