Detecting new record

[John]

Hi

In After Update event of form I am using the below code to distinguish
between a new record or an existing record;

If Me.NewRecord Then
......
Else
......
End If

Problem is that me.newrecord always returns zero (false) even if a new
record has been inserted. What is the problem and how can I fix it?

Thanks

Regards

[Allen Browne]

Any chance of using the form's AfterInsert event instead of AfterUpdate?

If not, you will need to declare a module-level boolean variable to indicate
if it was a new record, and set it in Form_BeforeUpdate.

1. In the General Declarations section of the form's module (at the top,
just after the Option statements):
Private mbWasNewRecord As Boolean

2. In Form_BeforeUpdate:
mbWasNewRecord = Me.NewRecord

3. In Form_AfterUpdate:
If mbWasNewRecord Then

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" <Jo**@nospam.infovis.co.ukwrote in message
news:OZ**************@TK2MSFTNGP03.phx.gbl...

>
In After Update event of form I am using the below code to distinguish
between a new record or an existing record;

If Me.NewRecord Then
......
Else
......
End If

Problem is that me.newrecord always returns zero (false) even if a new
record has been inserted. What is the problem and how can I fix it?

[Van T. Dinh]

In the Form_AfterUpdate Event, the "recently new" Record is no longer as New
Record as it has been updated into the Table thus the NewRecord is always
False.

I am not sure what you are trying to do but try the Form_BeforeUpdate Event.

--
HTH
Van T. Dinh
MVP (Access)

"John" <Jo**@nospam.infovis.co.ukwrote in message
news:OZ**************@TK2MSFTNGP03.phx.gbl...

Hi

In After Update event of form I am using the below code to distinguish
between a new record or an existing record;

If Me.NewRecord Then
......
Else
......
End If

Problem is that me.newrecord always returns zero (false) even if a new
record has been inserted. What is the problem and how can I fix it?

Thanks

Regards

[Lyle Fairfield]

John wrote:

Hi

In After Update event of form I am using the below code to distinguish
between a new record or an existing record;

If Me.NewRecord Then
......
Else
......
End If

Problem is that me.newrecord always returns zero (false) even if a new
record has been inserted. What is the problem and how can I fix it?

Thanks

Regards

Tomorrow never comes.

[missinglinq via AccessMonster.com]

What exactly are trying to do in the AfterUpdate event? I think the problem
is that AfterUpdate means AfterUpdate! The record is no longer "new" because
the record has been saved!

John wrote:

>Hi

In After Update event of form I am using the below code to distinguish
between a new record or an existing record;

If Me.NewRecord Then
......
Else
......
End If

Problem is that me.newrecord always returns zero (false) even if a new
record has been inserted. What is the problem and how can I fix it?

Thanks

Regards

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200701/1

[Van T. Dinh]

Tomorrow never comes.

The new improved _poetical_ version of Access???

--
Cheers
Van
"Lyle Fairfield" <ly***********@aim.comwrote in message
news:11**********************@q40g2000cwq.googlegr oups.com...

[Larry Linson]

"Van T. Dinh" wrote

>Tomorrow never comes.

The new improved _poetical_ version of Access???

And "Yesterday is always past."

:-)

[Dirk Goldgar]

"Lyle Fairfield" <ly***********@aim.comwrote in message
news:11**********************@q40g2000cwq.googlegr oups.com

>
Tomorrow never comes.

Data every other day. Data yesterday, and data tomorrow, but never data
today. Today isn't any *other* day, you know.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)