Is it Dimmed?

Hi James
After Googling the error -
"We see it in situations where someone is trying to sequentially run a large number of Reports, or likewise run a series of complex Queries, where each Query (excepting the initial one) is based on the previously run Query. In a situation like

Code:
DoCmd.OpenQuery "QueryA"
DoCmd.OpenQuery "QueryB"
DoCmd.OpenQuery "QueryC"
the problem can be resolved using the DoEvents Command.
Code:
DoCmd.OpenQuery "QueryA"
DoEvents
DoCmd.OpenQuery "QueryB"
DoEvents
DoCmd.OpenQuery "QueryC"
DoEvents returns control to Windows, allowing QueryA to complete running before starting to run QueryB. It then allows QueryB to finish running before starting QueryC. You might want to try breaking up your code by using it at strategic points. Having no experience with transactions, I can't really tell you where to insert it, but perhaps inserting it between each transaction might do it. So play around with it and see what happens."

john

Hey John, it is Dim as DAO.Recordset.

The error says "too many transactions being nested." Maybe you're using too many BeginTrans, CommitTrans, Rollback, etc. within one another.

Hey James
Didn't see it in screen clip!
John