Record Exit Eevent

  • Thread starter Thread starter per
  • Start date Start date
P

per

According to the help documentation for Access 2002, a RecordExit event
should exist, but it is nowhere to be found! In Knowledge Base article
304139 Microsoft tries to show how to programmatically implement such an
event using the ADO programming model. However, what they show is a Record
Enter event since the current record when the event procedure is executed is
the target record and NOT the record one is leaving.
Does anybody know how to program a real "record exit event"?
 
per said:
According to the help documentation for Access 2002, a RecordExit
event should exist, but it is nowhere to be found! In Knowledge Base
article 304139 Microsoft tries to show how to programmatically
implement such an event using the ADO programming model. However,
what they show is a Record Enter event since the current record when
the event procedure is executed is the target record and NOT the
record one is leaving.
Does anybody know how to program a real "record exit event"?
Click to expand...

Despite the help file, the RecordExit event does not exist in Access
2002. They may have added it in Access 2003, for all I know, but the
event didn't make the final release cut of Access 2002.

I haven't tried the technique in KB article 304139, and it uses an ADO
recordset event which is completely unfamilar to me, but it looks to me
as though it should fire the fRecordExit event before the form moves to
a new record. What are you actually observing?
 
What I observe is the new record; and, if Cancel is set to True it reverts
back to the original record!
 
per said:
What I observe is the new record; and, if Cancel is set to True it
reverts back to the original record!
Click to expand...

Interesting. That's different from what I would expect from my reading
of the KB article and the ADO help on the WillMove event. The KB
article says that the fRecordExit, implemented as outlined in the
article, fires before the Current event for the next record. Have you
found that to be true? And, in the fRecordExit event procedure, if you
Debug.Print the values of the form controls, do you get the values from
the original record or the new one?
 
Back
Top