J
JK
I have asked this question before and had no takers :-(
Example:
Combo is base on a query which in turn based on a table eg:
tblCountries:
Country_ID (key)
Country (text) eg: "Australia"
ShortName (Text) eg: "Aus"
etc.
qryCountries:
SELECT Country,SHORTNAME,Country_ID FROM tblCountries
Combo:
SELECT SHORTNAME, Country,Country_ID FROM qryCountries
(Upper case is only for emphasis here)
(Please note "ShortName" is the *second* column in the query)
When I specify the "ForeColor" of the combo box to ,say, vbBlue, the colour
does *not *change (no errors).
HOWEVER, if I change Column(0) in the Combo to "Country" - no problems.
Sure, I can duplicate the query changing the first field of the *query* to
Column(0) of the combo box. I am trying to avoid it as this will entail
duplication of quite a few queries.
I hope that explained it better.
Any suggestions? (including "no can do")
Regards/JK
Example:
Combo is base on a query which in turn based on a table eg:
tblCountries:
Country_ID (key)
Country (text) eg: "Australia"
ShortName (Text) eg: "Aus"
etc.
qryCountries:
SELECT Country,SHORTNAME,Country_ID FROM tblCountries
Combo:
SELECT SHORTNAME, Country,Country_ID FROM qryCountries
(Upper case is only for emphasis here)
(Please note "ShortName" is the *second* column in the query)
When I specify the "ForeColor" of the combo box to ,say, vbBlue, the colour
does *not *change (no errors).
HOWEVER, if I change Column(0) in the Combo to "Country" - no problems.
Sure, I can duplicate the query changing the first field of the *query* to
Column(0) of the combo box. I am trying to avoid it as this will entail
duplication of quite a few queries.
I hope that explained it better.
Any suggestions? (including "no can do")
Regards/JK