how to retrieve multiple colums from a table using a listbox?

[schultzwf]

Access 2007- form
I am using a lookup file with multiple columns.

I use the table to populate a listbox.

I want to have the user click on an entry and retrieve multiple columns from
the lookup table.

For example:
Choosing 'physical exam' from listbox and i want to retrieve pay type, code,
and fee columns from the lookup table

 

[Beetle]

You can retrieve values from combo/list box columns by referring
to the Column property. It is a zero based index, so Column(0) is
the first column, Column(1) is the second, etc.

For example, a text box on your form could have a Control Source like;

=[lstyourListBox].Column(3)

or you could refer to it in code like;

Me![lstyourListBox].Column(3)