Hi Keith,
Even though the RowSource for the combo has become a cursor the ControlSource for the combo should still be the fieldname in the underlying table/view being modified. HTH
>Another quick question,
>
>This was asked by another developer here in the office, and I gave an answer that I would like to verify.
>
>Okay, he has a combo box (drop down list), and he has been using a table as the rowsource, and setting the controlsource to a field within the table.
>
>Interactive change event fires fine when he changes elements in the combo.
>
>Now he switches to a cursor for the rowsource within the combo box (same underlying table fields etc), NOW, when he switches between elements within the combo box, the interactive change event no longer fires.
>
>I STATED, that this was due to the controlsource being bound to the un-updateable cursor, and the underlying table was not changing, so the interactive change event would not fire...
>
>Is this correct?
>
>If he removes the control source, things should start working again?? EXCEPT he will end up with a blank in the first location of the combo box, if he does not explicitly define the value before showing.
>
>Thanks in advance...
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.