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.
>>>>>>>>but im trying to use a combo box so when i select A my fields get 5 and B gives me 10
>>>>>>>>when i init the form the field gets 5 but i dont get 10 upon the selection of B
>>>>>>>
>>>>>>>Re-read my reply one more time and also post how did you setup your comobox (what is its rowsourcetype and rowsource).
>>>>>>
>>>>>>my row source is an sql
>>>>>>select fields from table where intemtype="x" into cursor test
>>>>>>3-SQL satement
>>>>>
>>>>>Ok, fine. My original suggestion applies to your scenario.
>>>>
>>>>oh im going to try it on the int of the form
>>>
>>>No, try it in interactivechange (or valid) of the combobox. E.g.
>>>
>>>this.value = this.value && just in case
>>>
>>>and then my code.
>>
>>
>>hmmm not really.
>uhum that doesnt relaly work thou. i change my row source to fields an...it doesnt do whats its supposed 2
If it's not broken, fix it until it is.
My Blog