Creating a "Submit" button

[athyeh]

Hello,

I am creating a form and want this form to have a "Submit" button that:

1) "Saves" the information the user was inputting to a record
2) Creates a new record for input
3) Clears the form for the inputter

http://answers.microsoft.com/en-us/o...b-68b599b31bf5



I want to do this.

But I cannot get this to work....

Please help.

Thanks

[June7]

Record entry/edit on a bound form is committed to table when move to another record, close form, or run code.

All you have to do to save record and 'clear' the form is move to a new record. This can be done with the intrinsic Access navigation feature or with code (macro or VBA) behind a button.

Why doesn't it work - error message, wrong results, nothing happens?

Post attempted code for analysis.

[athyeh]

Hello,

Thank you for your reply. The code I currently have in my button is:
Private Sub Command24_Click()
RunCommand acCmdSaveRecord
Me.Requery
End Sub

I understand that but the inputters of this form are even less tech-savvy then I am and I just want to be able to have them into this form with as minimal explanation/instruction as possible.

When I click this button: Nothing Happens. No error message, wrong results, nothing.

Is it important to note that on this form that I have also included several dropdown menus, using LookUp Wizard with relationships to other tables?

[June7]

Is the record committed to table? That could happen and you would not really 'see' anything.

Try instead:

Private Sub Command24_Click()
DoCmd.GoToRecord , , acNewRec
End Sub

[athyeh]

Thank you.