Help on Adding or editing new records

M

Morgan

What I want to do is close a form depending of if they
change data or if it is a new record.

And close a form depending if it is a new record or a
existing record.

On first button ADD/EDIT

If "New record" (witch I don't know the command) Then
Rund Code that I have
Else
DoCmd.Close 'just close the form if they edited it.
 
T

Terry

Hello Morgan
What you want is Me.NewRecord

You can also tell whether an edit has taken place using
Me.Dirty
HTH
Terry
 

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

Adding data to MS Access from csv file 0
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0
How do I clear a form? 0
Copy previous record into form field 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Record Change Confirmation 8
My code stops after the record saves....form never closes 1
write conflicts 1

Top