p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Combo Box reference - stumped


Message #1 by "Haslett, Andrew" <andrew.haslett@i...> on Tue, 25 Jun 2002 14:56:53 +0930
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
Message #2 by "Haslett, Andrew" <andrew.haslett@i...> on Tue, 25 Jun 2002 15:36:50 +0930
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


  Return to Index