How can I pass multiple values with a combo box
Posted on 2006-03-31
I have a combo box setup on a vb form. I need to populate another combo box based on the value selected in the first one.
How can i pass the id of a record along with the name with a combo box?
This is part of my code that populates the combo box,
Dim cb As ComboBox
Set cb = Me.Controls(strComboName)
While Not recResult.EOF
In my program i can retrieve the value the user sees but i want to pass an id field along with every name displayed so i can use it to run another query.
Can somebody help with this?