>>>>>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.
If it's not broken, fix it until it is.
My Blog