DoLookUp-reference in a subform

[Leif Thorsen]

Subform reference !!

I hav a main form (named A1) and a subform (named A11).
On the subform I have a combo box in which I can choose an index in a table
containing a bunch of persons with their names,addresses, phone numbers etc.
The index I then store in an indexfield as a part of the subform fields.

When picking up an index from the combo box I want to use the
â€DoLookUpâ€-function to show the name of choosen person.

I hav tried a lot of versions of syntax but failed every time.

I found a nice expose in one of the questions in this discussion group – but
I failed ther too.

Can anyone give a hint how to solve my problem ??????

Thank You in advance

 

[NoodNutt]

G'day Leif

If all the information is in the combo just use an unbound control(s) to
display the name

eg

=cboYourCombo.Column(1)

Generally Column(0) is your first column which would normally contain the ID
no, then each consecutive will have misc info ei Name, Address, City,
etc......

HTH
Mark.

 

[Leif Thorsen]

Thank You for a simple solution - it worked

Have a nice day

 

[NoodNutt]

Your Welcomed Leif

It's makes it all worthwhile when people take the time to express their
appreciation via a simple thank you response.

Something I am seeing less and less these days in the NG's

Much appreciated

Mark.