Record locked by another session on this machine

  • Thread starter Thread starter Bill Sturdevant
  • Start date Start date
B

Bill Sturdevant

I have a main form with SubFormA

SubFormA has a subform SubFormX

In the SubFormA "Current" handler, I look at the values in
SubFormA and then call a routine in SubFormX to deactivate
some of its (SubFormX's) fields.

This works.

But when I change the routine in SubFormX to deactivate
AND zero out some of its fields, then any time I try to
change a field on SubFormA, I get an error (no
number) "Could not update; currently locked by another
session on this machine."

I have tried so many things at this point I am confused,
but the one thing I did try was to save the record in
SubFormX, and that did not help.

What am I doing wrong?
 
Try changing the subform >control< values, not the values of the database
fields to which they are bound.

That is:

me![sfA].form![sfX].form![txtBlah] = "xyz"
^ control.
not:

me![sfA].form![sfX].form![Blah] = "xyz"
^ field.

HTH,
TC
 
Back
Top