P
Pam
I have a form fGenInfo with several subforms but one in particular
fStatusSubform that I think is causing trouble. Database has been working
fine for several years and today started throwing "Error 2455-You entered an
expression that has an invalid reference to the property Form/Report."
The form has a requery button that shows a pop-up box asking for job number.
If the job number is entered, the form opens correctly. If no job is
entered (either pressing enter on keyboard or clicking ok on box), the
message appears. When I press debug, this is highlighted:
Private Sub Form_Load()
If IsNull(Me.fStatusSubform.Form.[RevisedPOReceived]) = True Then
MsgBox "REVISED PO NOT RECEIVED"
End If
End Sub
If I remove this section of code, it opens to a blank screen - no part of
the main or subforms are seen. As stated, it has been working fine for
years.
If anyone has a solution, I would greatly appreciate it.
Thanks in advance.
Pam
fStatusSubform that I think is causing trouble. Database has been working
fine for several years and today started throwing "Error 2455-You entered an
expression that has an invalid reference to the property Form/Report."
The form has a requery button that shows a pop-up box asking for job number.
If the job number is entered, the form opens correctly. If no job is
entered (either pressing enter on keyboard or clicking ok on box), the
message appears. When I press debug, this is highlighted:
Private Sub Form_Load()
If IsNull(Me.fStatusSubform.Form.[RevisedPOReceived]) = True Then
MsgBox "REVISED PO NOT RECEIVED"
End If
End Sub
If I remove this section of code, it opens to a blank screen - no part of
the main or subforms are seen. As stated, it has been working fine for
years.
If anyone has a solution, I would greatly appreciate it.
Thanks in advance.
Pam