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.
Printable View
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.
Moved to Office Development
You can use the Form_Dirty event but that will also detect other changes in the fields too instead of just rows being added.
One option is to remove the users ability to scroll to a new record via access and put a command button in its place.
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.