should save button be on main form or subform?

[freeskier]

Hello,

I am creating a form for data entry. The main form has personal (address, phone) information that is allready stored. the subform has blank fields for information that is being entered. The fields on the subform are stored in a different table than the personal information on the main form. Each form is bound to the corresponding table.

I use the code created by the wizard for the save button. something like:

Private Sub Command49_Click()
On Error GoTo Err_Command49_Click
 
 
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
 
Exit_Command49_Click:
    Exit Sub
 
Err_Command49_Click:
    MsgBox Err.Description
    Resume Exit_Command49_Click
 
End Sub
 

my question is, should the save button be on the subform, the main form, or both? The fields on the main form may be altered if user notices an error in personal information.

Thanks in advance for your time.

[ADezii]

Hello,

I am creating a form for data entry. The main form has personal (address, phone) information that is allready stored. the subform has blank fields for information that is being entered. The fields on the subform are stored in a different table than the personal information on the main form. Each form is bound to the corresponding table.

I use the code created by the wizard for the save button. something like:

Private Sub Command49_Click()
On Error GoTo Err_Command49_Click
 
 
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
 
Exit_Command49_Click:
    Exit Sub
 
Err_Command49_Click:
    MsgBox Err.Description
    Resume Exit_Command49_Click
 
End Sub
 

my question is, should the save button be on the subform, the main form, or both? The fields on the main form may be altered if user notices an error in personal information.

Thanks in advance for your time.

The Save Button can go on the Main Form.

[freeskier]

OK I am still not doing something right. My main form has two subforms one to check address information the other for information to be entered.

There is a combo box on the main form to select what person to check / add information for. The combobox's control source is the personID field.

When I save I get TWO new records
(1) just the personID and
(2) just the information entered and no personID.

I think it is saving the main form's only bound field (the combo box -> personID) and then saving the subforms as a different record.

Thanks for your help

[freeskier]

OK I am still not doing something right. My main form has two subforms one to check address information the other for information to be entered.

There is a combo box on the main form to select what person to check / add information for. The combobox's control source is the personID field.

When I save I get TWO new records
(1) just the personID and
(2) just the information entered and no personID.

I think it is saving the main form's only bound field (the combo box -> personID) and then saving the subforms as a different record.

Thanks for your help

never mind I fixed it. think I need more sleep. sorry for the bother.

[NeoPa]

never mind I fixed it. think I need more sleep. sorry for the bother.

Lol - let us know if you have more problems.