Thread: Error says object doesn't exist
08-06-07, 22:55 #1Registered User
- Join Date
- Feb 2002
Unanswered: Error says object doesn't exist
I have a database with a purchase order form and subform of the invoices received on that purchase order. I have a onclick on the invoice number and when clicked it is supposed to open the invoice form and show the invoice.
It used to work, but now I get
Error 2467:The Expression you entered refers to an object that is closed or doesn't exist.
The odd thing is, If I open the subform alone and click on the invoice number it works fine, but if I open the subform as part of the purchase order form, I get the error.
Both forms are open when I click it.
I have tried both of the following
DoCmd.OpenForm "APInvoice", acNormal
DoCmd.ApplyFilter , "APinvoicenumber=" & "'" & APInvoiceNumber & "'"
'DoCmd.OpenForm "APInvoice", , , "[APinvoicenumber]=" & "'" & APInvoiceNumber & "'"
08-06-07, 23:37 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
I assume that if you'd made modifications to your app just prior to this behavior appearing, you would have mentioed the fact! When something in Access works for a period of time, and then, without modifications being made, simply stops working, corruption is the first thing that comes to mind!Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007