General information
Title:
Comboboxes and Requerying
I'm really stuck with the following problem :
I am using comboboxes in my program. The Rowsource of the combobox is an
SQL-STATEMENT. When I run the program I sometimes get the message 'Cannot
access the selected table' followed by the error message ' Error
Combobox1.Requery '
In the following text, you can find the properties of my combobox. The
controlsource is a property of my Application class.
BoundColumn = 2
RowSourceType = 3
RowSource = "this.sqlselect"
ControlSource = "oApp.FiltGnsmTheraIndex"
Height = 25
Left = 192
Style = 0
Top = 76
Width = 217
ZOrderSet = 5
Name = "Okcombobox1"
PROCEDURE sqlselect
DO CASE
CASE oApp.clanguage = "N"
SELECT oms, tcode FROM Therapeutische_index ORDER BY oms INTO CURSOR
cthera
CASE oApp.clanguage = "F"
SELECT omsf, tcode FROM Therapeutische_index ORDER BY omsf INTO
CURSOR cthera
OTHERWISE
SELECT oms, tcode FROM Therapeutische_index ORDER BY oms INTO CURSOR
cthera
ENDCASE
ENDPROC
PROCEDURE Destroy
*-- Destroy the alias created in the RowSource property
IF USED("cthera")
USE IN cthera
ENDIF
ENDPROC
I hope anyone can help me !
Thanks a lot.
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