link combo box to table row
Posted on 2006-05-15
This is probably a dead-simple question, but I haven't done it yet.
I have a form with a table specified as the record source. The form has a combobox and several text boxes. The combo box's record source select all the table's keys. The other text boxes are bound to columns in the table. When I open the form it brings up the information for the 1st row in the table, including the key in the combo box.
When I pop-down the combo box and select a different key, the keyvalue changes in the combo box, but the other text boxes remain with the original data. So, changing the keyfield combo box value does not cause the form to requery the table data.
How do I make it do this?