Instead of AcSaveNo, what should i use to save record?

[xwnoob]

Hi,

I have read that the command AcSaveNo only saves the form, not data. So which code should i use to save the data in a form?

Heres my code

DoCmd.OpenForm "BorrowerSection", acNormal
DoCmd.Close acForm, "AddNewBorrower", acSaveNo

 

[Acke]

If fields on your form are directly connected to table, the data are being saved automatically. However, if you use unbound filed, you need to add a code that will store data in the table.

What, if anything, is declared as "Record Source" under the Form properties?

 

[vbaInet]

code should i use to save the data in a form?

DoCmd.RunCommand acCmdSaveRecord