Unanswered: Bound ComboBox
There's a field (lookup) on a table (table1) that looks up values on another table (table2). Now, I created a form for table1, the form automatically generated a combo box control for the field with a lookup. Now I created a unbound text box (txtBox1) on the form and on Form_Open procedure, I inserted this code
When the form opens, the value of lookup gets assign to txtBox1. But instead of the text appearing, a number appears. The lookup (combo box) is showing a string. But when I set it to equal to another control, it displays an integer. Now I know this is the index key, it is returning. How do I convert this to make it look exactly how the combo box is displaying it.
Private Sub Form_Open(Cancel As Integer)
txtBox1 = lookup
The only true wisdom is in knowing you know nothing.