Hi
I have the following question.
If I have a dataform with a Combobox control and want to change the SQL
selection statement at run time, how do I get the control to refetch the
data?
I have the following code:
oEvent.Source.Model.Parent.ComboBox2.isValid = false
oEvent.Source.Model.Parent.ComboBox2.setPropertyValue( "ListSource", sSQL )
oEvent.Source.Model.Parent.ComboBox2.reset
Now, I have tried isValid, and reset as you see. I have tried just about
every thing I can come up with. When I user explore the ListSource
string in the debugger it is changing to the new Select statement...but
try as I might I can not get the control to refetch! I ahve also set the
string with
ComboBox2.ListSource = sSQL
hoping that a accessor method might trigger the refetch...nope...
This is on OO.o 1.9.125
Thanks for you help in advance
Drew Jensen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
