Save/Add Record and Start New Record buttons

[kpo]

I created a form to enter new records into my database. I need to add two buttons at the end. One that will save the record info I just entered and start a new record. Another to save the record info I just entered and close the form. I have been searching and searching for the correct VBA code to use for these but what I have tried isn't saving the record into the source database. It is like it disappearing into thin air.

When I created the form I used the "Add Existing Fields" feature to add the correct fields to my form. I thought that would allow them to be linked to the correct table. Was I wrong?

Thanks in advance for the help!

[AccessMSSQL]

Your form should be bound to the table you are entering into: check the forms Recordsource property to make sure you are bound to a table. If the form is bound the only code you really need behind the button is something like this:
use any of these behind your save button
Docmd.Refresh
or
docmd.runcommand accmdSaveRecord

To save and exit just add this to the above code:
Docmd.Close acform, "[yourformnamehere]"

[AccessMSSQL]

Also, the fields on your form should be bound to a controlSource so make sure you check each textbox ControlSource property.

To go to next record use this:
docmd.RunCommand accmdRecordsGotoNew

[kpo]

Thank you so much!

the RecordSource and ControlSource are linked to the right place. I tried


DoCmd.RunCommand acCmdRecordsGoToNew


and this is what popped up...


Run-time error '2046':

The comand or action 'RecordsGoToNew' isn't available now.


I know it is difficult to troubleshoot when you can't see what I have done :/ I appreciate the help so much! if you need anymore details just ask.

THANK YOU!!

[kpo]

I fixed it. (haha for now)

I had the wrong field set up as the primary key and that was throwing everything off.

THANK YOU!!