>>If you want to use combobox as a navigation mechanism, use any rowsource except for fields and navigate to the selected record using seek or go to approach.
>
>
>err well the seek approach errr when i add the code on interactive change
>and changes the value of the combo box
>it
>the combo box disables itself..odd
Don't use Fields as the recordsource for your combo, use something else. Also this combo should be unbound (empty controlsource).
If it's not broken, fix it until it is.
My Blog