Susan Harkins
harkinsss at bellsouth.net
Mon Mar 13 09:02:53 CST 2006
Nevermind -- it never fails that I get it right the very next time after asking for help. Array(Empty, Empty, "Shippers", Empty )) Susan H. Set rst = CurrentProject.Connection.OpenSchema(adSchemaColumns, Array(Empty, Empty, Empty, "Shippers")) I can't remember the exact syntax for filtering a schema recordset to a specific table -- anyone remember which array element I'm supposed to use. I've moved the table name around, but I either get an error or an empty recordset. Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.1/279 - Release Date: 3/10/2006