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
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