I've noticed some unusual things in Access 2002 regarding when Form.BeforeInsert fires off and when Form.BeforeUpdate fires off.
I'm trying to do an action immediately before the physical insertion into the access database.
While in insert mode, what is happening is...
The BEFOREINSERT for the form module fires off immiediately after I type the first character into the form.
And the BEFOREUPDATE for the form module fires off immediately before the physical insert.
Since I want to run some code before an insert and not an update, the above behavior does not help.
My question... Is there an indicator (like a global environment variable) that indicates that a form is in INSERT mode? This would solve my problem.
Thanks in advance for any help.
I'm trying to do an action immediately before the physical insertion into the access database.
While in insert mode, what is happening is...
The BEFOREINSERT for the form module fires off immiediately after I type the first character into the form.
And the BEFOREUPDATE for the form module fires off immediately before the physical insert.
Since I want to run some code before an insert and not an update, the above behavior does not help.
My question... Is there an indicator (like a global environment variable) that indicates that a form is in INSERT mode? This would solve my problem.
Thanks in advance for any help.
