Can you use an alias for the combo's RowSource instead?
See also
http://berezniker.com/content/pages/visual-foxpro/cannot-access-selected-table-error-1152>Hi All:
>
>I have a combo class with the rowsourcetype = SQL Statement.
>
>The statement reads thus:
>
>
>sele dist Cde from itlook where cnatable = 'PRTDISP' into curs "Z"+ substr(sys(2015),3,10)
>
>
>The itlook table contains two possible values, 'Display' or 'Print'.
>
>This problem started when I wrote the init method:
>
>In the init I have:
>
>
>this.Value = 'Display'
>
>
>In some forms that use this combo, I'm getting the following message when instantiating the form:
>
>
>Cannot access the selected table
>
>
>It then appends the SQL code.
>
>Again, This problem started when I wrote the init method.
>
>What gives?
>
>Yossi
If it's not broken, fix it until it is.
My Blog