Hi Experts,
My database has Main form and a Sub form.
On main form i place one unbound text box named investigations.
In subform of which datasheet there is a column named TestCode.
I want unbound text box (Investigations) to display row values which selected in a column (TestCode) of subform.
for example
Investigation field should display "CBC,HB,ALP" like this
for further reference Sample database attached
Any help will be appreciated.
Thanks
My database has Main form and a Sub form.
On main form i place one unbound text box named investigations.
In subform of which datasheet there is a column named TestCode.
I want unbound text box (Investigations) to display row values which selected in a column (TestCode) of subform.
for example
Investigation field should display "CBC,HB,ALP" like this
for further reference Sample database attached
Any help will be appreciated.
Thanks