Originally Posted by
smbrush
I have a form with a combo box control and a subform in datasheet view. They are both populated from the same database table. The combo box has the values of one of the columns in the subform.
How can I retrieve a value from a subform row selected by the user and then use that value in code for the main form? I want to place the value in the text box portion of the combo box and then fire its AfterUpdate event.
There are only two events available for the subform, neither of which are effective for capturing user clicks on subform rows. The main form's OnCurrent event doesn't fire when the user clicks on subform rows, as well. What event do I use for code to determine which subform row the user has clicked on?