how to display more then one column in a Look up column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Look up Column Based on a the following code
SELECT [Available Memberships].Category, [Available
Memberships].Description, [Available Memberships].Fee FROM [Available
Memberships] WHERE ((([Available Memberships].MemAgeGroup)=Forms!Members![Age
Group]));

When i make a selection from the look up column only the first column is a
available how can i do to make the other two columns visible as well. I tried
to do two unbound text boxes but they don't seem to work

thanks
 
Lookup fields aren't particularly useful. See
http://www.mvps.org/access/lookupfields.htm at "The Access Web" for some of
the reasons.

Realistically, if you can use a lookup field, that implies that all of the
information in the second table is directly related to whatever's selected.
That means you should be storing the additional information: only what's
required to look it up.

If this is for display purposes only, the recommended approach is that you
use a combo box on a form. In the AfterUpdate event of the combo box, you
can refer to the Column collection to display the additional information.
For example, if you want the information from the 2nd column of the combo
box to go into Text1, and the information from the 3rd column to go into
Text2, you'd use something like:

Private Sub MyCombo_AfterUpdate()
Me.Text1 = Me.MyCombo.Column(1)
Me.Text2 = Me.MyCombo.Column(2)
End Sub

Note that the Column collection starts numbering at 0.
 
Back
Top