Stuart McLachlan
stuart at lexacorp.com.pg
Mon Jul 12 00:55:08 CDT 2004
On 12 Jul 2004 at 17:37, David Emerson wrote:
> I have finally got round to implementing Bob's code. It is working well
> but I have a problem with combo boxes. In cases where there are more than
> 1 columns and the first column is an ID number, I would like to show the
> 2nd column value (which is what is shown on the screen as the first column
> is 0cm width).
>
> I can get the new value of the combo box with "C.Column(1)" (C is dimmed as
> a control). How do I get the old value of the 2nd column though?
>
You can't from the combobox directly, you will have to get it from the
underlying data, something like
=DLookup("DisplayName","tblLookupTable","PK = " & cboC)
--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.