Object invalid or no longer set

P

Paul

I have an Access 2000 child form in which the source query
is updated in an AfterUpdate event
with 'DoCmd.RunSQL "update ..." '. This update is
followed by a Parent.Refresh. This works fine with MS Jet
Service Pack 6. However, with Service Pack 7, I receive
an "Object invalid or no longer set" error. I see in
Knowledge Base article 304536 that SP 6 was supposed to
correct an error like this (although it doesn't sound
quite like it was the same situation). Does anyone have
any thoughts on what may cause this problem?

I'm running Win 2000 and the tables are in the same Access
mdb file with the form and the code. No link tables.

I admit I'm pretty new to Access/VBA applications and I
inherited this one. Thanks in advance for thoughts.

Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3420 Object Invalid or no longer set. 11
URGENT: Cannot Open Any More Tables 1
Setting a parent form value based on a subform entry 0
Object invalid or no longer set error involving database object. H 7
Run-time error '5': Invalid procedure call or argument 3
Access 2010 in Windows 7 woes 0
There is no object in this control 3
Run-time error 2046 - need help with workaround 2

Top