display row text from subform column in unbound textBox of Main form (1 Viewer)

drp

Registered User.
Local time
Yesterday, 17:29
Joined
Dec 4, 2010
Messages
16
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
 

Attachments

  • drp_Sample.mdb
    228 KB · Views: 69

JHB

Have been here a while
Local time
Today, 01:29
Joined
Jun 17, 2012
Messages
7,732
Is it so you mean, database attached?
 

Attachments

  • drp_Sample.mdb
    316 KB · Views: 76

drp

Registered User.
Local time
Yesterday, 17:29
Joined
Dec 4, 2010
Messages
16
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

Have been here a while
Local time
Today, 01:29
Joined
Jun 17, 2012
Messages
7,732
Okay - then so.
 

Attachments

  • drp_Sample.mdb
    348 KB · Views: 84

drp

Registered User.
Local time
Yesterday, 17:29
Joined
Dec 4, 2010
Messages
16
Hi JHB

This works as I want. Save my lot of time

Thank u very much

drp
 

JHB

Have been here a while
Local time
Today, 01:29
Joined
Jun 17, 2012
Messages
7,732
You're welcome, luck with your project.
 

Users who are viewing this thread

Top Bottom