General information
Category:
Forms & Form designer
Title:
How to create auto update combo box
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only