>I have a listbox with the rowsourcetype set to 3 - SQL Statement, and in the rowsource I haver a query that uses the distinct clause. When I run the form I get an error that says can not access the selected table. Why would this error occur?
>
>Thanks,
>Matthew
This is common list/combo problem. It usually happens when you try to overwrite rowsource (I had it when rowsource is cursor's alias). To avoid this problem, it's necessary to clean rowsource before each reset.
Thisform.List1.Rowsource=""
Select .... Into cursor curListsource
Thisform.List1.Rowsource="curListsource"
Edward Pikman
Independent Consultant