>>>>>>>>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
>
>An example of what I am trying to do is: if mylistbox1.value ='TURTLE' (from table1), I want comboxbox1 to show only 'TURTLE' (from table2)
Something like this:
myCombo.RowSource = "SELECT myField from table2 WHERE table2.myField = mylistbox1.value INTO cursor combobox1source"
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison