Hi
I am wanting to display two columns in my dropdown combo (eg. StNo and Street). The combo is on the second field (Street).
I specify a lookup RowSource=Cust.Stno,Street and a RowSourceType=6-Fields.
I set BoundColumn=2.
This works fine except when I select the row I want it displays the contents of column 1 instead of column 2 (displays the Stno but I want the Street) in the text portion.
I have tried setting the DisplayValue but this had no effect.
What am I doing wrong and how do I get my Street field to display?
Regards
Geoff Scott
May all your weeds be wildflowers