Before next record event?

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

Jeff Klein

Is there an event that takes place before a form moves to a new record? I
want perform some field checking before it moves to the new record.
 
I think that is "before update" If you open the properties box and place
your cursor in one of the events, the status bar at the bottom of your
screen will tell you what each even means.

Rick B
 
So long as you edit data in the record, the form's BeforeUpdate event would
be the appopriate event, as Rick says. If no data editing is done, however,
then there is no event that you can use.
 
There was actually a RecordExit Event planned but removed from AccessXP. It
would have been lovely if it had been left in. For grins, here are the KB
articles about it. The third article gives you a way to implement this
functionality using ADO.

ACC2002: RecordExit Event Unavailable in Microsoft Access 2002
http://support.microsoft.com/default.aspx?scid=kb;en-us;286477&Product=acc2002

ACC2002: RecordExit Event in Employees Form Does Not Work
http://support.microsoft.com/default.aspx?scid=kb;EN-US;286591

ACC2002: How to Programmatically Implement a RecordExit Event
http://support.microsoft.com/default.aspx?scid=kb;en-us;304139&Product=acc2002
 
Back
Top