cmd btn works correctly in form Add mode but not in form Edit Mode?

[RLehrbass]

Ok,
If I load the form [frmMember] in 'Add mode', fill it out, click my save button (performs DoCmd.RunCommand acCmdSaveRecord) the cmdAddANewMember button on frmMember works correctly and re-loads frmMember in 'Add Mode', but...


If I load the form [frmMember] in 'Edit mode', whether I make some Edits or not, and/or click the Save button or not, the same cmdAddANewMember button says
"You can't go to the specified record."

How can I correct this to work in both 'Add Mode' and 'Edit Mode' conditions?
or better yet, how can I make the cmdAddANewMember button disapear in the edit mode???

This is the Code I am using at this time:

Private Sub cdmAddANewMember_Click()
On Error GoTo Err_cdmAddANewMember_Click

DoCmd.GoToRecord , , acNewRec

Exit_cdmAddANewMember_Click:
Exit Sub

Err_cdmAddANewMember_Click:
MsgBox Err.Description
Resume Exit_cdmAddANewMember_Click

End Sub

[ItsMe]

Can you show the code you are using for Edit mode? Perhaps the type of editing you wish to do is not what the code is asking Access to do.

[RLehrbass]

Its the same form, the only thing different is from the switchboard, i have a add new member and a edit/view new member selection.
Both load the same form.
I have attached the DB for your review of this issue.

Membership-database-ConstructionFormIsWorking62515.zip

FYI, I am A Novice and I knew nothing of VBA prior to creating this DB...
I started with the Membership DB template and have seriously modified the heck out of this.
Moderator has helped me greatly over the past few weeks with some of the forms financial coding issues.
I have not gotten to the reports area yet, so what reports exist are not mine and do not apply.
I have not removed them so I will have basic reports to review when making my reports.
I have played with a few reports just to see what they are like.

[ItsMe]

I looked at your DB. The form named frmMember had its Allow Additions property set to = No.

You can adjust this to = Yes via the property sheet while in Design View of the form. The Allow Additions property is under the Data Tab.

[June7]

Set the form properties as needed.

Me.AllowAdditions = True

[RLehrbass]

Moderator,
How would I apply your suggestion. Would it be inserted into the cmdAddANewMember_Click() code?
I actually did not set the allow additions property to no, I believe this was done by Access in the view in edit mode setting of the switchboard.
Would you recommend to change the property or add the code?

[June7]

If you want to keep switching back and forth between allowing new and not allowing new, then use code behind the buttons. Setting AllowAdditions to yes in form design won't help if you then open the form in Edit mode. If you then want to add record, will need to change the form's 'mode'.

Why bother with Edit mode? Just open form filtered to the one record to edit. This will still allow movement to new record row if the AllowAdditions property is set to yes. Users won't be able to navigate to other records. One form can be made to work so users can navigate all records, find a specific record, add new record. This can be done with intrinsic tools or through custom buttons and code. The more 'user friendly', the more code.

The save record command might not be needed. Record is committed to table when move to another record, close form, or run SaveRecord code.

[RLehrbass]

Moderator,
1) I changed the property field to additions = yes.
2) I need to stay on the current record after inputting new member information, so i can either add committee member or payment from this form, without moving off record in some fashion then returning, the save button resolved it nicely. I tried refresh and requery but neither would actually save to the table without leaving current record. but then-again, that may also be due to the allow additions setting. Perhaps I was trying the code in the edit mode??? hence, next experiment! try refresh and requery with the allow add set to yes.

[June7]

Then that is reasonable use of save record code. Refresh and Requery will move focus to first record of the form's dataset, no matter what mode.