Am I at a "New Record?" How to tell?

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

In Access2003, I need to know if a user is in the process of adding a NEW
record as opposed to modifying a current one. The latter I have covered via
DIRTY, but I really need to know if it's a new rec.

Can someone please throw out a few ideas?

Thanks!!
 
In Access2003, I need to know if a user is in the process of adding a NEW
record as opposed to modifying a current one. The latter I have covered via
DIRTY, but I really need to know if it's a new rec.

Can someone please throw out a few ideas?

Thanks!!
Click to expand...

Code the Form's Current event:
If Me.NewRecord = true then
' It's a new record
' Do whatever you need here
Else
' It's not a new record
End If
 
Thanks! That did it.

Dennis


fredg said:
Code the Form's Current event:
If Me.NewRecord = true then
' It's a new record
' Do whatever you need here
Else
' It's not a new record
End If
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Unbound Form needing to add new record 7
How to tell if I'm adding a new record 3
Viewing the current record after requery a form 2
I am using VBA, how do you test for new record in a form 1
SubForm does not accept focus when adding a new record ? 4
Lookup current record with ComboBox, any changes create new record 3
Append Records from a subform to a new record 1

Back
Top