R
Rick Seltzer
I have a database which has been running without a problem for a year. This
problem, which just started, occurs on about half the computers at a
non-profit. On the computers when it occurs, it occurs about 80% of the
time. All computers use Windows XP and Office 2003. All software has been
updated and all programs have been compacted and repaired.
This line of code occurs when the main client form is opened (OnCurrent).
It sets certain rights for editing the form depending the record number.
Me.AllowEdits = False
Me.AllowDeletions = False
Me.sfrClntContact.Form.AllowEdits = False
Me.sfrClntContact.Form.AllowAdditions = False
(another half-dozen) subforms are also referenced accordingly.
The first two lines run OK (changing the main form). However, when it tries
to change any of the subforms the following error occurs: you entered an
expression that has an invalid reference to the property form/report. Run
time error 2455
Sometimes if I exit Access and sign back in, the code works.
It is totally bizarre as the error is intermittent.
I suspect that the subforms are not properly loaded when they are
referenced. However, when the process is not solved by stepping through the
code or letting it sleep.
Any help would be deeply appreciated.
Rick
problem, which just started, occurs on about half the computers at a
non-profit. On the computers when it occurs, it occurs about 80% of the
time. All computers use Windows XP and Office 2003. All software has been
updated and all programs have been compacted and repaired.
This line of code occurs when the main client form is opened (OnCurrent).
It sets certain rights for editing the form depending the record number.
Me.AllowEdits = False
Me.AllowDeletions = False
Me.sfrClntContact.Form.AllowEdits = False
Me.sfrClntContact.Form.AllowAdditions = False
(another half-dozen) subforms are also referenced accordingly.
The first two lines run OK (changing the main form). However, when it tries
to change any of the subforms the following error occurs: you entered an
expression that has an invalid reference to the property form/report. Run
time error 2455
Sometimes if I exit Access and sign back in, the code works.
It is totally bizarre as the error is intermittent.
I suspect that the subforms are not properly loaded when they are
referenced. However, when the process is not solved by stepping through the
code or letting it sleep.
Any help would be deeply appreciated.
Rick