>If I have a combo box with 2 columns, how can I get the value of column two to be displayed when the box is not dropped down.
-------------- Reply
Matthew:
Are you trying to display both columns when the combbox is not dropped? What about arranging your rowsource so that the strings in column 1 and column 2 are cancatated (sp?) into column 1, i.e.
SELECT;
TRIM(a.column1var)+TRIM(a.column2var) ;
FROM columsourcetable a ;
INTO array aRowSource
instead of
SELECT;
TRIM(a.column1var),;
TRIM(a.column2var) ;
FROM columnsourcetable a ;
INTO array aRowSource
This will have the effect of assigning colum1+colum2 to your controlsource field, so you will have to play with refresh() and lostfocus() to ensure that only the column1 part of the .value gets back to your table.
I have not done it, but do not see why it cannot be done.
Regards,
JME
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.