Hi All
Access 2002/2007
WinXPPro
Anyone seen this before?
I have a form with a subform. On the subform is a Combobox. The Rowsource and ControlSource of the ComboBox is edited from a button's proc in the main form.
1. Row Source Type is always Table/Query
2. Rowsource is set to a table e.g. My_Table1 with autonum ID
3. Controlsource is set to a field from the subform's recordsource e.g. My_Table2.My_Table1_ID
4. I requery the Combobox each time.
5. listrows = 10
This all works happily and the ComboBox scrolls to the correct record in the relevant table which can be seen in first row if one clicks the drop-down control....
What it does not do, however, is to display the record in the display portion of the combo...
By default my subform is in datasheet view.... if I flick it into form view the combobox displays the record correctly and continues to do so if I then flick back to datasheet view........??
I've re-imported the form & re-created the combobox but no joy...
derrr.....
thanks
Access 2002/2007
WinXPPro
Anyone seen this before?
I have a form with a subform. On the subform is a Combobox. The Rowsource and ControlSource of the ComboBox is edited from a button's proc in the main form.
1. Row Source Type is always Table/Query
2. Rowsource is set to a table e.g. My_Table1 with autonum ID
3. Controlsource is set to a field from the subform's recordsource e.g. My_Table2.My_Table1_ID
4. I requery the Combobox each time.
5. listrows = 10
This all works happily and the ComboBox scrolls to the correct record in the relevant table which can be seen in first row if one clicks the drop-down control....
What it does not do, however, is to display the record in the display portion of the combo...
By default my subform is in datasheet view.... if I flick it into form view the combobox displays the record correctly and continues to do so if I then flick back to datasheet view........??
I've re-imported the form & re-created the combobox but no joy...
derrr.....
thanks