save record

[ashu.doc]

Hi
I want to use an "enter " button at the end of my form to feed the data to table, rather that Tab to feed it. I have used save record function but also want to add a msg bob when I press save record button which says record has been saved.


Also, want to remove that feature of Tab feeeding data when I fill the form.

thanks

[June7]

Is the form in Single or Continuous view?

After the save code:
MsgBox "Record saved"

If you don't want form to cycle to next record, set the Cycle property to CurrentRecord.

[ashu.doc]

Is the form in Single or Continuous view?

After the save code:
MsgBox "Record saved"

If you don't want form to cycle to next record, set the Cycle property to CurrentRecord.

Sorry, I dont know much about the codes, it says this code for enter button

Private Sub Cmd_enter_Click()
On Error GoTo Err_Cmd_enter_Click

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Exit_Cmd_enter_Click:
Exit Sub
Err_Cmd_enter_Click:
MsgBox Err.Description
Resume Exit_Cmd_enter_Click

End Sub

can you tell me where should i put the message box code ?

[ashu.doc]

Can you actually give me full code which save data and show msgbox?

[June7]

I would use:

DoCmd.RunCommand acCmdSaveRecord
MsgBox "Record Saved"

The error handling stuff is your option.