Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo box limits another combo box
Message
 
 
To
06/05/2014 13:23:00
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01599629
Message ID:
01599630
Views:
73
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform