>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
Dragos,
That select is done to populate combo isn't it ? If so make it directly the rowsource and change rowsourcetype to 3 -SQL.
This is legal :
.RowSource= 'select .. from pacient where .. ' +;
' fise.dct=val(thisform.combo1.value)) into cursor results'
and requery gets new set.
Cetin