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

 

[Guest]

Try running it in Form_Current instead. After Update is too late--it's no
longer new.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[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

 

[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.

 

[Lyle Fairfield]

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.

 

[Van T. Dinh]

Tomorrow never comes.

The new improved _poetical_ version of Access???

--
Cheers
Van


news:[email protected]...

 

[Larry Linson]

"Van T. Dinh" wrote

The new improved _poetical_ version of Access???

And "Yesterday is always past."

 

[Dirk Goldgar]

Tomorrow never comes.

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