How to check if record is in "update" or "insert" mode

scheeps

Registered User.
Local time
Tomorrow, 03:03
Joined
Mar 10, 2011
Messages
82
I've got a scenario where I need to set a combo box value depending if the record is being updated:

Code:
Me!cboDataStatus = "Corrected"

or if the record is an insert:

Code:
Me!cboDataStatus = "Initial"

But how do I programmatically check if the record is going to be added or updated?

I'm sure it must be possible with a simple If statement but I can't seem to locate it on previous threads.
 
This might work:

If (Me.NewRecord) Then
 
Thanks a lot Paul.

I knew it is going to be something very simple.
 

Users who are viewing this thread

Back
Top Bottom