Hi Gang,

I have an unbound 2-columned combo-box, which gets it's recordsource from a
table.  I wish to change the displayed item in this combobox, based on
another control, which holds the equivalent bound-column's value.

i.e. The combo box is called cboProperty. The control which holds the value
I wish to set the combo box to, is called txtProperty.  Why can't I set the
combobox's current (selected) item in VBA, by using:

me.cboProperty = me.txtProperty

txtProperty holds the correct value of the bound column in the combo-box, so
I'm unsure why it's returning a blank in the combo box.

Thanks in advance,
Andrew

Sorry, scratch that - brain meltdown.  

me.txtProperty was returning an erroneous value.

AH

-----Original Message-----
From: Haslett, Andrew [mailto:andrew.haslett@i...]
Sent: Tuesday, 25 June 2002 2:57 PM
To: Access
Subject: [access] Combo Box reference - stumped


Hi Gang,

I have an unbound 2-columned combo-box, which gets it's recordsource from a
table.  I wish to change the displayed item in this combobox, based on
another control, which holds the equivalent bound-column's value.

i.e. The combo box is called cboProperty. The control which holds the value
I wish to set the combo box to, is called txtProperty.  Why can't I set the
combobox's current (selected) item in VBA, by using:

me.cboProperty = me.txtProperty

txtProperty holds the correct value of the bound column in the combo-box, so
I'm unsure why it's returning a blank in the combo box.

Thanks in advance,
Andrew