DoLookUp-reference in a subform

  • Thread starter Thread starter Leif Thorsen
  • Start date Start date
L

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
 
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.
 
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.
 
Back
Top