>>>a simple exercise I am looking to solve. I have combo1 with values from a field and another combo2 the same but I want combo2 choices to be limited depending on the value of combo1. Can you tell me where I put the code for this?
>>
>>In the gotfocus of combo2 check the value of combo1
>
>Where would I put the code to set the value of combo2 (judging from the value of combo1)?

As above, in the gotfocus of combo2.