>I have a combobox which selects data from a table with sql into a cursor on loading, which works fine - the combo box is filled with the correct data. I then right click in another control (list box) which brings up another form with some of the information of the first form filled in, allowing the user to complete the entry. When the user exits this form, I get the message "cannot access the selected table" and the combobox is no longer on the first form. If I use 'fields' instead of sql it works, but I would like to use sql for everything.
>
>Sql statement - select all consult.consult from consult.dbf into cursor clconsult
>
>I have other combo boxes on the form which do the exact same thing and work fine, just not this one. I have deleted the control and started over and re-entered the sql numerous times but can't find the problem. Any suggestions would be appreciated.
>
>
>Paul
The cursor created with the SQL Select is closed before the form.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer