chrisjames25
Registered User.
- Local time
- Today, 09:01
- Joined
- Dec 1, 2014
- Messages
- 401
Hi
I have a form where i have 3 comboboxes, PotSize, Pot Shape, Pot Colour. These are independent of each and not linked in any way.
As i select each combobox i want it to populate a Final Pot Name in a text box below the comboboxes.
For example if i choose 2L (potsize) Round (pot shape) and Teraacotta(pot colour) i want the text box to state:
"2L-Round-Terracotta"
In each combobox the first column is the id number of the table not the describing field so can can i get it to populate the words rather than id numbers:
Currently have this code in afterupdate of each combobox:
Problem is the answer i am getting is "2-2-17 rather than "2L-Round-Terracotta"
Any help much appreciated
I have a form where i have 3 comboboxes, PotSize, Pot Shape, Pot Colour. These are independent of each and not linked in any way.
As i select each combobox i want it to populate a Final Pot Name in a text box below the comboboxes.
For example if i choose 2L (potsize) Round (pot shape) and Teraacotta(pot colour) i want the text box to state:
"2L-Round-Terracotta"
In each combobox the first column is the id number of the table not the describing field so can can i get it to populate the words rather than id numbers:
Currently have this code in afterupdate of each combobox:
Code:
Me.Txt_NewTier2.Value = Me.Cbo_Tier1.Value & "-" & Me.Cbo_Tier2.Value & "-" & Me.Cbo_Tier3.Value
Problem is the answer i am getting is "2-2-17 rather than "2L-Round-Terracotta"
Any help much appreciated