What event is triggered to ask if you want to save the current record

when the second key part of a 3-part key is changed? OI asks if you

want to save the current record before it calls up the new record with

the changed ID (usually a blank record). I want to stop the chaining of the events prior to

OI asking if you want to save the current record so I can manipulate the ID/RECORD.

This is an on going problem I'm beginning to work on again. I need to

change any part of a multipart key and have my subroutine save the "old" record under the "new" ID and ask if the old record should be

deleted…..aka AREV.

Thanks…

Steve C.

Steve,

Could you perhaps - instead of fighting the built-in event handling - have *two* sets of key fields in your form - one databound and hidden, and one not databound and visible? Then you could fiddle about with values in the non-bound controls as much as you wanted, and just get and set the real key fields when you really wanted to? Just a thought.

- Oystein -

Oystein,

Not a bad idea. If I can't do it easily with OI event

handling your suggestion may give me the best control

of changing the key of a current record..

Thanks…..

Steve C.

I would guess it would be the lostfocus event that does the initial trigger, but it could be changed.

akaplan@sprezzatura.com

Sprezzatura, Inc.

View this thread on the forum...