Just a WAG. Try Dim dbs As DAO.Database. Without the DAO, you can get strange error messages when trying to access properties. On 15 Nov 2016 at 19:29, John R Bartow wrote: > Dim dbs As Database