Run the code only if it new record

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

Guest

I want to post a value on a Text control of a form IF ONLY the current Record
is new. If it is old/already edited record it should produce error. I will be
running this code on a mouse click event of a lablel.

Please advise.

Regards.


Irshad.
 
If Me.NewRecord Then
'Run your code
Else
MsgBox "This is not a new record"
End If
 
You must log in or register to reply here.

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

How to limit the subform records 1
Dont Move to Next/Save form if any Null field 6
Timer Interval Event Code 8
Dlookup related code 2
Loop through subform records - Help required 12
Need combo box to refresh when moving to new record 2017 1
First date and last date of the current month 3
VBA code to call first date of the year and last date of the year 2

Back
Top