Rx_
Nothing In Moderation
- Local time
- Yesterday, 18:22
- Joined
- Oct 22, 2009
- Messages
- 2,803
Couldn't not find this on Access World Forums. This is a VBA question.
Figured it out, so just posted the answer for others rather than a question.
Combo Box Name: MyComboBox
Control Source: Customers
Column Count: 2
Column Widths: 0";2"
Row Source: SELECT Customers.ID_Customers, Customers.Customers_Name.....From...
Bound Column: 1
Will write code in the Before_Update event.
What object code would provide both values?
(for example to pass into a function)
Answer:
MyCustomerID = Me!MyComboBox.Column(0)
MyCustomerName= Me!MyComboBox.Column(1)
Figured it out, so just posted the answer for others rather than a question.
Combo Box Name: MyComboBox
Control Source: Customers
Column Count: 2
Column Widths: 0";2"
Row Source: SELECT Customers.ID_Customers, Customers.Customers_Name.....From...
Bound Column: 1
Will write code in the Before_Update event.
What object code would provide both values?
(for example to pass into a function)
Answer:
MyCustomerID = Me!MyComboBox.Column(0)
MyCustomerName= Me!MyComboBox.Column(1)