G
Guest
Hello. I have a main form (frmClient) and on it there is a tab control. On
one of the tab pages I have 2 subforms (sfrmCarrier, sfrmPolicy), both are
continous style. The frmClient and sfrmCarrier are linked properly. I now
have sfrmPolicy linked to sfrmCarrier using the child/master properties;
Child = CarrierID
Master = [sfrmCarrierSubform].Form![CarrierID]
I have used this same method on several other tab pages with 2 subforms.
Those all work fine. I have reviewed the tables, the forms, settings, and so
on and it all looks fine. But I am puzzled as to why the sfrmPolicy does not
always display the FK coming over from sfrmCarrier. The other tabs that have
2 subforms shows as soon as I begin a new record. When i go to enter a new
record, the textbox field for CarrierID will be blank. But the oddity is
there are times when the sfrmPolicy acts perfectly by displaying the FK from
sfrmCarrier. I have tried refreshing and requerying the subform before
entering a new record but that is not the answer either. I am at a loss and
to the point of deleting it all and starting over.
Does anyone have any thoughts about why the field does not always populate?
Thanks to those who respond.
one of the tab pages I have 2 subforms (sfrmCarrier, sfrmPolicy), both are
continous style. The frmClient and sfrmCarrier are linked properly. I now
have sfrmPolicy linked to sfrmCarrier using the child/master properties;
Child = CarrierID
Master = [sfrmCarrierSubform].Form![CarrierID]
I have used this same method on several other tab pages with 2 subforms.
Those all work fine. I have reviewed the tables, the forms, settings, and so
on and it all looks fine. But I am puzzled as to why the sfrmPolicy does not
always display the FK coming over from sfrmCarrier. The other tabs that have
2 subforms shows as soon as I begin a new record. When i go to enter a new
record, the textbox field for CarrierID will be blank. But the oddity is
there are times when the sfrmPolicy acts perfectly by displaying the FK from
sfrmCarrier. I have tried refreshing and requerying the subform before
entering a new record but that is not the answer either. I am at a loss and
to the point of deleting it all and starting over.
Does anyone have any thoughts about why the field does not always populate?
Thanks to those who respond.