>>>>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).
> i change it to SQL again also i had too unbound it...but now...:( it doesnt change the field values like 5 and 10 thou the combo box changes normally again
>
>
>Also
>
>lnpk=thisform.combo1.value
>if seek(lnpk,'profit' ,'id')
>thisform.refresh()
>endif
>
>profit being a table and id being a primary key
Is ID integer or numeric? If yes, then BoundTo property of the combo should be true (if I recall correctly - it should be changed from default value to opposite).
Try debugging this piece of code.
If it's not broken, fix it until it is.
My Blog