Save Button on a Form

[psyam]

Hi,
I have a form with save button on it.All I want it to do is ..Save the data on the form to the table .
This is the code I am using:
Private Sub btnSave_Click()
DoCmd.RunCommand acCmdSave
'DoCmd.Save
End Sub

But the form is unable to save the data on to the table.

Thanks for ur time...

 

[gol4]

Is the form bound to the table you are wanting to save to?

 

[ProgramError]

The name of the table should be in the record source property of the form.




Program Error
Programmers do it one finger at a time!

 

[Eupher]

psyam,

Wrong command. acCmdSave is the command to save design changes to a form or report in design view. I think you want acCmdSaveRecord.

HTH,

Ken S.

 

[psyam]

Ya, Thank you. acCmdSaveRecord is serving the purpose.


Thanks,
Syam.