Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Cannot access selected table error, rowsourcetype=6
I get 'cannot access selected table' error in my .REFRESH() as rowsourcetype is assigned to 6. The error only occurs 1st time the code is executed (at this time, the combolist dissapear from the screen). Subsequent run does not give error (combolist reappear, properly populated). Oh, actually, when the form is loaded the very 1st time (at which time .REFRESH() is also executed), I get no error & combolist displayed correctly. When I then clicked on my update button which calls the .REFRESH(), I get the error & combolist dissapear. If I clicked on in again, then combolist reappear & no error message.
In THISFORM.Refresh():
*********************
SELECT ALLTRIM(last)+', '+first as xAuthoFor,cAutho.authofor ;
FROM cAutho LEFT JOIN cEmp ON cAutho.authofor=cEmp.empid ;
WHERE UPPER(cAutho.empid)=UPPER(cERCA.enterBy) INTO CURSOR xCAutho
*xCAutho is OK at this point (I can browse it).
THISFORM.PageFrame.Page4.lSubmitFor.RowSourceType= 6
*This is when I can the 'cannot access selected table' error.
THISFORM.PageFrame.Page4.lSubmitFor.RowSource='xCAutho.xauthofor,authofor'
*********************
Any help would be greatly appreciated.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement