Save Form

[cmw]

I have a save command button in a form. I click it then save record to a table. But record save it before button_click(). How will detect it? Am I save main form and subform by one mainform save_button_click()?

 

[wazz]

try using the Form_BeforeUpdate event with a message box to confirm saving record.

you can save the subform and main form separately by adding code to both forms.

if you don't have any code on your subform, records on the subform will be saved when you leave the subform. if you are entering data in the subform and your Save button is on the main form then the subform data will be saved when you click the Save button.

 

[cmw]

Please help me. How will write for mainform and subform save when mainform save button click(). Mainform Form_BeforeInsert() or Form_BeforeUpdate() event work before subform enter. But I dont want this. I want only form save main form and subform through save button.

 

[wazz]

main form saves when you enter subform. subform saves when you leave it. i think they must be done separately.

if you don't want the main record after entry in subform then i guess you must delete the main form record.

 

[cmw]

I have written insert command in mainform After_insert() or After_Update() Event for a Form field value insert or update into another table field value except mainform and subform table. Mainform insertion work before entering data in subform. So Subform value can't insert table filed value , and after leave the subform i enter some charges field value. so I want Atlast value stored into one table except mainform and subform table.
How will do insert and also if form update ,how will do update?