In the Current Event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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