>>>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