I found the problem below was caused by when doing a select in a form I used opendatabase for the set of the database object and not currentdb. I just donot understand why when I was trying to teach myself VBA that their are examples, in help, that donot work properly. I would never encounted...