>Hi. VFP7 user. In a form, I have a combo box that limits the selection of a second combo box (ex: 1st box choice: bedroom 2nd box: dresser,bed,nightstand). I am using a filter for this. However, when I execute the filter, my program restarts and I lose all of my variables. Is there a better way?
>Thanks, Randy
Yes.
In the first combo interactive change try
this.parent.SecondCombo.RowSource = ""
select ... from .. where = this.value into cursor csrSecondCombo
this.parent.SecondCombo.RowSource = 'csrSecondCombo'
this.parent.SecondCombo.requery()
If it's not broken, fix it until it is.
My Blog