Thanks.Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.
Also Left a Function you might be interested in. It allows remote DLookup Capabilities, without connecting the tables to the Front End. It does require a Set dbObjVariable = DBEngine.OpenDatabase statement though, but after that works great.