>>>>>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...)
>>
>>That's correct.
>
>Each time I do this I find myself saying "Oh yeah, I forgot to add this to the form.init() again..." :)

Can you tell me where the sql code is inserted and also in using sql so I don't end up with a browse screen as a result of my select?