Profile.zip
Hi all,
How on earth do I reference a sub form on a sub form?
I created a form (frmContactUs)
Set its record source to tblBusinessEntity
I placed sub form on it called sfrmBusinessEntity and sfrmBusinessAddress and then put that form in my primary form as a subform.
I am trying to get the BusinessEntityID to be on the subform SfrmBusinessAddress
Cannot get it to change once I select a different Business Entity Record? I set the Master / Child to BusinessEntityID
But it has not recognized it so thinking its because its a subform on a sub form?
In any event, Is there a way to link that ID field so that when I change entity, it changes the ID in the other subform?
Reason being is a Business can have multiple entities, each entity can have multiple addresses
Any ideas maybe? db attached, opens to Form in question!
Thanks
Dave