By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Requery failure causing GPF in MSAccess.exe- is this a known bug? Is there a fix/

P: n/a
I am runing Access 2000 across a network running on Server 2000 with
Win95/98/2000 on local machines. Whilst developiong the front end, the
front end and back end are both located on the server.

I have a form with two subforms. The main form has a one-to-many
relqationship with subform1, which in turn has a one-to-many
relationship with subform2 (called "Elements Subform" in the code
below - I now know that it is bad practice to leave sapces in your
object names, but I didn't at the time of naming.)

The code below is attached to the On Current Property of Subform1 and
refreshes subform2 to show only those records relating to the selected
rcord in subform1.

************************************************** ****
************************************************** ****
"Sub Form_Current()
Dim ParentDocName As String

On Error Resume Next
ParentDocName = Me.Parent.Name

If Err <> 0 Then
GoTo Form_Current_Exit
Else
On Error GoTo Form_Current_Err
Me.Parent![Elements Subform].Requery
End If

Form_Current_Exit:
Exit Sub

Form_Current_Err:
MsgBox Error$
Resume Form_Current_Exit

End Sub
**************************************************
************************************************** *

Generally this has worked, but users are increasingly reporting that
subform2 fails to update. Initially no error is generated but when
they try to close the form, a GPF is produces in MSAccess.exe. One
user has also reported an error message reffering to a failed
Query_Def.

Can anyone explain
1. what is happening? and
2. is there a fix.

Many thanks in anticipation of someone's assistance.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.