Bill Benson (vbacreations)
vbacreations at gmail.com
Fri May 21 13:38:06 CDT 2010
And if I try to delete the for manually Access tells me The Search Key was not found in any record. -----Original Message----- From: Bill Benson (vbacreations) [mailto:vbacreations at gmail.com] Sent: Friday, May 21, 2010 2:36 PM To: 'Access Developers discussion and problem solving' Subject: Access confused about its own objects Access 2003 continues to plague me, I am getting this message now: The Microsoft Jet database engine could not find the object '~sq_fBILL__subfrmControlsList'. Make sure the object exists and that you spell its name and the path name correctly. When I am trying to delete (for the second time) the form named BILL__subfrmControlsList This is my process, to delete a form (if it exists), rebuild it, attach it as a sourceobject to s subform, set that subform sourceobject back to "", delete the form, repeat ... as often as required. It does not help to have a command which says ?DoCmd.DeleteObject acForm, MyForm Where MyForm is BILL__subfrmControlsList And have access (1) not do it and (2) tell me that what it tried to delete was ~sq_fBILL__subfrmControlsList. Does someone know why this is happening?