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