Nick, a quest. When you hard code the rowsourcetype into the property pallette, does this take precedence over when you do it programmatically?
this.RowSource = "SELECT name,noun from bsyear00 WHERE subs(bsyear00.noun,2)?
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"
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."