Error 3246: Operation not supported in transactions.?

[(PeteCresswell)]

I've got a parent form with two subforms.

Subform#1 lists bond funds.

Subform#2 lists global market values for the currently-selected fund.

Subform#1's Form_Current updates a record ID field in the parent, and then
requeries Subform#2 - whose .RecordSource query looks at the parent's record ID
field.

Works fine when walking subform#1's fund names.

But when I delete a row from Subform#1, it fires Form_Current, which attempts
the requery and traps out with "Error 3246: Operation not supported in
transactions"


The puzzling thing about this is that I'm using apparently identical strategies
for several other subform pairs with no problem.

LinkChildFields and LinkMasterFields are not used - either in the problem case
or in the cases that work.

Anybody been here? I'm thinking some difference in the form props... but
eyeballing them hasn't turned anything up.

 

[(PeteCresswell)]

Per (PeteCresswell):

I've got a parent form with two subforms.

Form the maschocistically (SP?) inclined, there's a sample app
at http://tinyurl.com/yarst5

Zipped, about 300k. MS Access 2003.

The problem is with "Funds". Try deleting a fund.

You'll have to click the forms system "Close" box and hit Escape a bunch of
times to get out of the error loop.