General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
>>I have a form with two combo boxes. The output from the first (i.e. the controlsource - say Thisform.var1) is to be used to determine the data displayed in the second combobox by means of a filter based on var1 in an SQL statement in the RowSource. What is the best way to pass the controlsource to the SQL statement? Thisform.var1 is not allowed in the SQL statement in the rowsource. I have got round it by using a private variable in the form but I feel this is not the correct way to do it.
>
>You can
>
>bindevent(thisform, "var1", combo2, "requery")
>
>and in the requery you can use aEvents() function to determine who called it, or you can go directly for luVar1=thisform.var1 and then use luVar1 in your SQL statement. You may bind the combo to the cursor instead of the statement, as you'd be running the statement programmatically (and I'm not sure if the variable would be visible in the SQL if you just set it in .requery() and then did a dodefault()).
Thanks Dragan, that put me on the right track. I passed in Var1 as a parameter to the Requery of the second combo, and in the requery ran the SQL and set the rowsource of the second combo to the resulting cursor.
Barry.
Previous
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