Thanks for any who would reply.

I have located this post which I think answers my question:

http://bytes.com/topic/access/answer...ction-question

If there is anything that you feel would help me further, I'd be happy to hear from you.

Regards,
Terry Van de Velde...

Hello,

I am attempting to write an application where I have code segregation where code dealing with the form is located in the form which relies on a class module (ie clsOrders) and all code that specifically deals with database connection, manipulation, etc is resident in it's own standard module.

I am using ADO and Access 2003 at the moment. I am wondering what the best method is to implement transaction processing....