display row text from subform column in unbound textBox of Main form

[drp]

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

 

[JHB]

Is it so you mean, database attached?

 

[drp]

Hi JHB
Thank U for showing interest

In your reply DB, investigations field shows only one row at a time (due to giving control source "=tbl_Sub!TestCode". It is ok But I want to display all the three rows i.e first row of column testCode (ALB) Then 2nd row of coliumn TestCode (Cal) and 3rd Row of column TestCode (CBC) in Single TextBox Control i.e Investigations at time separated by comma
for example in this case, Investigations field show "ALB,Cal,CBC" and not single row.

please come up with solution.
Thanking U

 

[JHB]

Okay - then so.

 

[drp]

Hi JHB

This works as I want. Save my lot of time

Thank u very much

drp

 

[JHB]

You're welcome, luck with your project.