Originally Posted by
kiri19
...for the delete button i have: DoCmd.RunCommand acCmdDeleteRecord but it does not seem to be deleting.
If you try to Delete a Record that is New, i.e. it has not been Saved, you can't...there is no Record to Delete! In this circumstance you'd need to Undo the data, simply using Me.Undo.
If this is a Record that has been Saved, I believe you need to 'Select' the Record before Deleting it:
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
As you've found out, trying to use Access in a manner that goes against the native way it is intended to be used, and against the way that experienced Access users are accustomed to it working, i.e. only Saving a Record if a Save button is clicked, is
usually problematic. Also, if your button is actually called/labeled 'ADD NEW CLIENT,' most users, certainly all experienced Access users, are going to assume that they need to click the button in order to start a New Record, not to Save the one they just filled in.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007