Hi Mark, than you for the response.
I have a follow up.
The parent form name is actually Contact Details (I incorrectly ref'd as frmContacts.
I referenced in code as
[Contact Details].subFormControl.SourceObject = ""
but errors and says cant find the field referred to in the expression. I guess its due to the form name. Not sure if brackets is necessary or something else. If have a sec please let me know...thank you in advance.
HI Mark, thanks for the advice! Its working. Not quite as intended but its good enough.
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.