In the Current Event

S

SHIPP

I have got some code that I want executed if the user is editing a record. If the user is adding a record I want to bypass the code. Is there an Access built-in flag that dictates whether one is editing or adding a record? Any help would be appreciated.
 
M

Marshall Barton

SHIPP said:
I have got some code that I want executed if the user is editing a record. If the user is adding a record I want to bypass the code. Is there an Access built-in flag that dictates whether one is editing or adding a record? Any help would be appreciated.
Click to expand...

In general you can use:

If Me.NewRecord = False Then
. . .
 
C

Cheryl Fischer

Have you checked out the Form's NewRecord property? That may be what
you're looking for.


hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


SHIPP said:
I have got some code that I want executed if the user is editing a record.
Click to expand...
If the user is adding a record I want to bypass the code. Is there an Access
built-in flag that dictates whether one is editing or adding a record? Any
help would be appreciated.
 
Top