General information
Category:
Forms & Form designer
>At 1st combobox InteractiveChangeEvent issue the following:
>
>Thisform.cState_name = This.Value
>Thisform.2ndCombox.Requery()
>
>Your 2nd ComboBox should have the following SQL:
>
>SELECT states.username, st_name FROM states WHERE states.st_name = Thisform.cState_name INTO cursor ComNames
>
>For Correct DisplayValue of the 2nd Combobox, the Bound Property should be set to 2 instead of 1 which is the default.
The 2nd Combo-Box will return the Error 'Thisform can only be used in a Method'
for your reference to thisform.cState_name in the SQL Statement. I have worked
around the problem like 1000 times but was wondering what was the 'right' way.
Thanx!
Bob :-)
Previous
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