I would look into useing DAO 3.6 instead of the DoCmd
Read up on collections in the Help file and how to add and remove objects from the database collection
You will have to add Microsoft DAO 3.6 in from references
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.