Using an example
Access 2003
create a table with 3 fields, add some random data
create a second table with one field
set the lookup parameters to
SELECT Table1.f3, Table1.f2, Table1.f1 FROM Table1;
Bound Column 1
Column Count 3
Heads Yes
Widths 2cm;2cm;2cm
List Width 6cm
I get the desired effect of 3 columns of data displayed and the column 1 data stored when selected...
I was assuming that to select data from the 2nd or 3rd column instead, I would only need to set bound column to 2 (or 3) But I only ever get the data from the first column.
Start Free Trial
