Requery error

white6174

Board Regular
Joined
May 6, 2002
Messages
137
I'm trying to do a requery of a form after a new record is entered from a pop-up form when it closes

I get the error after the second time a requery the form

the error message is: object invalid or no longer set

Everything works fine on most computers (works on 6 fine, 2 get the error)
the database is on a novell network

I also get the error message when I manually requery the form

thanks for any help you can provide
steve w

here's the code

Private Sub Command109_Click()
On Error GoTo Err_Command109_Click


DoCmd.Close
DoCmd.SelectObject acForm, "Main", False
DoCmd.Requery
Exit_Command109_Click:
Exit Sub

Err_Command109_Click:
MsgBox Err.Description
Resume Exit_Command109_Click

End Sub
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
I am not sure what is actualy causing the erroe but you could try specifying the object to requery to see if that helps.
Me.frmMyForm.Requery

HTH

Peter
 
Upvote 0

Forum statistics

Threads
1,221,558
Messages
6,160,484
Members
451,651
Latest member
Penapensil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top