Help on Adding or editing new records

  • Thread starter Thread starter Morgan
  • Start date Start date
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.
 
Hello Morgan
What you want is Me.NewRecord

You can also tell whether an edit has taken place using
Me.Dirty
HTH
Terry
 
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

Need combo box to refresh when moving to new record 2017 1
Record Change Confirmation 8
Access Automatically Send a notification email once a record is added 0
If I open a form, add a new record, close the form (without saving or changing records) will it stil 1
write conflicts 1
Creating Checkbox Fields For Every Record 0
Continuous form refresh/requery 3
Tables("MainTable").mycombo = Me.CurrentRecord.IDField ? 4

Back
Top