>>>>>>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?

The SQL itself goes to Combo.RowSource property.

Combo.RowSourceType = 3
myCombo.RowSource = "SELECT myfield from mytable where somefield = somevalue INTO cursor myCombo1Source"

This way you will not get a Browse window.
Don't forget to close that cursor in Combo.Destroy()

*Combo.Destroy()
IF USED(" myCombo1Source")
USE IN myCombo1Source
ENDIF