General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a method in a form that makes the refresh to a list of patinets, the select statement is rather simple:
select pacient.link,alltr(pacient.name)+' '+alltr(pacient.surname);
as name from pacient where link in (select distinct fise.link from ;
fise where fise.dct=val(thisform.combo1.value)) into cursor results
and than i initialize the combo's items:
1: thisform.combo2.rowsourcetype=2
2: thisform.combo2.rowsource="rezultate"
3:
4: this.combo2.requery
the error while appear after line 1, because i checked that and that is:
"Cannot access the selected table" - if you can give me any advice for the reason of this error i'll verry grateful to you!
ps: i tried the change the lines between them, because i thought that by initialising the rowsourcetype with 2, it will try to requery it at once,and because the rowsource is "None", i thought there could be a possible error, but it is not!
thanx for you help!
DADO
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