Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create auto update combo box
Message
From
19/06/2002 04:26:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
How to create auto update combo box
Miscellaneous
Thread ID:
00670040
Message ID:
00670040
Views:
45
Sorry guys for bothering you again, I never really had much chance to do work in foxpro till this job. (I am more used to the linux no visual programming environment)
I have a quick question, I have put 2 combo boxes in a form, combo A and combo B.
I want to use SQL to pull data into combo A which was sucessfull, but then, I want to pull data into combo B using the selected result from Combo A as one of the parameter in SQL. Unfortunately, after entering the SQL code .. something similar... select A.A from A where this.parent.combo1.value

I got errored out, it said something like I cannot use 'this' in a sql row source control. How can I do this now? I have tried to issue a this.parent.rowsource = sql statement. It doesn't quite work, is it me or is there a easier way or trick you guys can teach me?

Thankx guys~
Tom
Next
Reply
Map
View

Click here to load this message in the networking platform