I have a main form (DeliverySlipMain), with a subform (DeliverySlipSub22) with an embedded subform (DeliverySlipSub22a). My problem is that a control (cont) that is on the subform (DeliverySlipSub22) requires the value within the control (cont) of the embedded subform (DeliverySlipSub22a). This is accomplished by the following coding on the "Got Focus" of the field on the subform (DeliverySlipSub22):
Private Sub Cont_GotFocus()
Forms![DeliverySlipMain]![DeliverySlipSub22].Form![Cont] = Forms![DeliverySlipMain]![DeliverySlipSub22].Form![DeliverySlipSub22a].Form![Cont]
This information is required because the information contained within the subform (DeliverySlipSub22a) contains the default info set up for the customer, but I have to allow the shipper to override this information to change and save with the delivery record without comprising the default or to allow the default.
When tabbing into the field, the following error is received: