How do you add a record

[Greg Ripper]

How do I add a record in single for view with a button instead of using the
navigation buttons?

I have a form that I use the close form button close, but it will not give
the error message about having a duplicate primary key.

Is there another way to enter the data so that the data is entered and tested
before the form closes?

Rip

 

[Allen Browne]

This is a very long-standing bug in Access. As you found it *silently* loses
your entry when you use the Close action if there is any reason the record
cannot be saved (such as duplicate key value or required field missing or
validation rule not met, or ...)

The workaround - once you realise that Access is losing your entry - is to
code to save the record before using the Close action:


Private Sub cmdClose_Click()
If Me.Dirty Then
Me.Dirty = False
End If
DoCmd.Close acForm, Me.Name
End Sub

If the save fails, you receive an error message, and so the close line never
executes. Use error handling to handle the error.

 

[Greg Ripper]

Works Great! Thanks
Rip

This is a very long-standing bug in Access. As you found it *silently* loses
your entry when you use the Close action if there is any reason the record
cannot be saved (such as duplicate key value or required field missing or
validation rule not met, or ...)

The workaround - once you realise that Access is losing your entry - is to
code to save the record before using the Close action:


Private Sub cmdClose_Click()
If Me.Dirty Then
Me.Dirty = False
End If
DoCmd.Close acForm, Me.Name
End Sub

If the save fails, you receive an error message, and so the close line never
executes. Use error handling to handle the error.