Saving record but including Fields in Subform

[mohsinhq]

structure:

Form and sub form - need to include firlds from both the form and subform in the save.

Have a tabe which includes all the fields i want to save and are coded to save.

.Fields("Country") = Me.txtCountry
.Fields("Shipment #") = Me.cboShip
.Fields("PBL") = Me.cboLoc
.Fields("Ship_To") = Me.[CUSTOMER_NUMBER]
etc...

it works when i dont include fields from the subform but not when i start to reference to the subform within the save command.

i.e.

.Fields("PBL_2") = [BDPU_LOV_Data_Phase2 subform1].[LOCATION_ID]

Any ideas/suggestions?

thanks in advance

 

[Rich]

Why not just use Bound forms?

 

[mohsinhq]

This might be a stupid question.. but how do i do that?

 

[TheStig]

Use set value in a macro this will take the sub form value & set the value in the main form

 

[Rich]

This might be a stupid question.. but how do i do that?

Use the Form Wizard, it'll create the Forms for you