Before next record event?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Klein - 03 Mar 2005 20:54 GMT

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.

Reply to this Message

Rick B - 03 Mar 2005 21:00 GMT

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

> 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.

Reply to this Message

Ken Snell [MVP] - 03 Mar 2005 21:25 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

>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
[quoted text clipped - 5 lines]
>> I
>> want perform some field checking before it moves to the new record.

Reply to this Message

Sandra Daigle - 03 Mar 2005 21:40 GMT

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

Signature

Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

> 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.

Reply to this Message