[ACCESS 2003] New record event catching?

**smilbuta** · Jul 2nd, 2007, 08:17 AM

How to test to see if a new record was started?

When the user preses the next button or new record button on the tool bar in a access form it starts a new record. I want to test for this event and execute some code.

Any help would be appreciated.

**Hack** · Jul 5th, 2007, 12:34 PM

Moved to Office Development

**RobDog888** · Jul 5th, 2007, 01:22 PM

You can use the Form_Dirty event but that will also detect other changes in the fields too instead of just rows being added.

**Xilbus** · Jul 9th, 2007, 02:42 PM

One option is to remove the users ability to scroll to a new record via access and put a command button in its place.

**RobDog888** · Jul 9th, 2007, 03:10 PM

I just re-read tis and it sounds like you are wanting to catch two different events.

One is the navigation to another record. This event is the Form_Current and you can catch it in there to do whatever.

The other is the clicking of the New Record button but the new record is not actually committed until valid data is entered so the row can be committed.

What are you needing to do in these events? Maybe there is a better way.

Thread: [ACCESS 2003] New record event catching?

Thread Tools

Display

[ACCESS 2003] New record event catching?

Re: [ACCESS 2003] New record event catching?

Re: [ACCESS 2003] New record event catching?

Re: [ACCESS 2003] New record event catching?

Re: [ACCESS 2003] New record event catching?

Posting Permissions