Does your table reside in sql server? if so, there must exist a primary key in it

Try something like this:

strSort = "[tablename].crs_CoreID,[tablename].crs_CourseID,[tablename].Delname"

Thanks ps

It was really usefull your information

I develop systems using MS Access projects (*.ADP), I know almost nothing of SQL Server 2005

The DBA is migrating SQL databases from 2000 to 2005 and the use of schemas...