Unanswered: Can't select anything in adp combo box
D'Oh! I haven't messed around with Access in years but I know I've done this dozens of times.
I have a combo box pointed at a view. The view has 6 columns but I've limited the combo box to display only 4. These 4 are displayed in the combo box, nicely with headers, and it would just be beautiful if I could actually select one of them. However, click or type as may, nothing is ever 'selected'.
I did google for a while and found no one else was dumb enough to have this problem. I did see some references to items listed below:
The form holding the control is not bound and its source is set to 'Updatable Snapshot' since null wasn't an option.
I have specified one column from the view as the ControlSource for the combo box.