"Operation not supported in transactions" error message

[Guest]

I'm getting the above message when the following happens:

I have a normal form with two sub-forms. When I delete a record in the sub-form, it initiates a macro that requeries the entire main form and 2 sub-forms in order to populate various fields including calculated fields.

The error above is occurring immediately when the requery command is issued as part of the macro.

I've tried moving the focus from the sub-form to the main form before issuing the requery command but it's not working - same error message appears.

I would be grateful for a solution that doesn't involve VB code (however crude it might need to be) as I've never used VB coding in my database and wouldn't know how to!

 

[TOER]

*I'm getting the above message when the following happens:

I have a normal form with two sub-forms. When I delete a record i
the sub-form, it initiates a macro that requeries the entire mai
form and 2 sub-forms in order to populate various fields includin
calculated fields.

The error above is occurring immediately when the requery command i
issued as part of the macro.

I've tried moving the focus from the sub-form to the main form befor
issuing the requery command but it's not working - same error messag
appears.

I would be grateful for a solution that doesn't involve VB cod
(however crude it might need to be) as I've never used VB coding i
my database and wouldn't know how to! *

Has anybody yet an answer to this question? You MAY explain using VB!
have equal and/or similar and/or related behaviour using linked-fiel
subforms, but cannot track it, is it possible to find out what exactl
happens?


-
TOE