Is there a way to deactivate FormDependentValue once it has been activated?

Once it is activated, it stays active until I exit the form. But, I wanted to have it active or deactive based on the value in a "Category" field.

Hammer wrote on Jan 24^th, 2008 at 5:31pm:
I know. But you know me, I like to force Sesame in directions you never intended.

Actually, I'm currently getting along pretty well using XResultSet commands and loops to do what I want, with one exception. When I delete a subform record, the parent value doesn't update (unless I click on a command button I created for this issue). FormDependentValue takes care of that for me. But I only want to place the sum of the values in the subrecords, on the parent if the Category is a particular value. Otherwise, I want the parent form's value placed in the subform (that's the reason I wanted to deactivate FormDependentValue for some records).

I seem to remember that there was a command that would let SBasic know that a subform record was just deleted, but I can find it in the programming guide (probably, because I'm not searching on the correct name). Am I imagining things, or does such a command exist?

Hammer wrote on Jan 24^th, 2008 at 6:07pm:

Good idea.

Quote:

That's it! No wonder I couldn't find the command, it's not a command, it's an event.

Thank you very much.

Quote:

Your issues are never a waste of time, Carl. I'm glad you found a way to do what you wanted and took the time to share it with the rest of us.