Saving a form with subform

[jharding08]

I have a form that has a subform (subform1) and a subform (subform2) in that. The data is entered in the subform2, but I need subform1 to save a record as well. I default a textbox to the ID I need to save, but it wont save because I dont enter any data in that form. What is the call I need to make to save that subform1?

 

[Minty]

A default value isn't seen as data entry or a change in field.
You would need to set it via VBA to effect a change in the records "state".

 

[jharding08]

A default value isn't seen as data entry or a change in field.
You would need to set it via VBA to effect a change in the records "state".

Which form event should I set the variable in?

 

[jharding08]

I did it in the subform Before Insert and it seems to work

 

[gemma-the-husky]

I have a form that has a subform (subform1) and a subform (subform2) in that. The data is entered in the subform2, but I need subform1 to save a record as well. I default a textbox to the ID I need to save, but it wont save because I dont enter any data in that form. What is the call I need to make to save that subform1?

Really, you should think about your process. You shouldn't be able to create a subrecord until AFTER you create the parent record.

so, eg

CREATE a Customer THEN
CREATE an Order for that Customer THEN
CREATE Order Lines for the Order.