>I have the following code in the GotFocus Event of a Combo Box (Combo1)
>
>select distinct loc_mast.loc_name,tran_trans.location ;
>from data\tran_trans,data\loc_mast where tran_trans.location = loc_mast.loc_code ;
>order by loc_mast.loc_name into cursor locarea
>
>this.boundColumn=2
>this.rowsource='locarea.loc_name,location'
>this.rowsourcetype=2
>
>After I lose focus from this control and move to the next control and due to some reason I use Shift+Tab to go back to combo1 control I get the following error
>
>"Cannot Access Selected Table"
>
>Pls. Help
>
>Regards
>Ravi
Simply move that SQL to combo.rowsource and set rowsourcetype = SQL.
Cetin