>>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?
>>thanks
>
>Hmm, may be set the Combo2.RowSourceType to 3 -SQL Statement, which SQL will depend on value selected in Combo1? Then you call
>Combo2.Requery()
>Combo2.Refresh()
>in Combo1.Valid() or Combo1.InteractiveChange()

and in Combo1.Init (or in Form.Init, to be sure, in order to initialize the second combo properly at first time...)