S
shane
I have a table where the fields ecd (expected completion date) and acd
(actual completion date), and acdlate exist.
I have two forms "complaints1" and "acdlate".
If in "complaints1" the acd entered is greater than the ecd I want form
"acdlate" to pop up on the same record for which the dates were entered.
"acdlate" has fields "notificationnumber" and "reasonlate".
all fields come from the same table "complaints".
In complaints1 on the update event for "acd" I have entered the code
Private Sub ACD_AfterUpdate()
If Forms!complaints1!ECD < Forms!complaints1!ACD Then
DoCmd.OpenForm "acdlate", , , Forms!acdlate!notificationnumber =
Forms!complaints1!notificationnumber, acFormEdit, acDialog
End If
End Sub
When the acd field is updated with a date greater than ecd I see the erro:
"...couldn't find the form "acdlate"...." Spelling is correct. What's going
on?
form acdlate is set up with the border = dialogue and popup = yes.
Any help is appreciated.
(actual completion date), and acdlate exist.
I have two forms "complaints1" and "acdlate".
If in "complaints1" the acd entered is greater than the ecd I want form
"acdlate" to pop up on the same record for which the dates were entered.
"acdlate" has fields "notificationnumber" and "reasonlate".
all fields come from the same table "complaints".
In complaints1 on the update event for "acd" I have entered the code
Private Sub ACD_AfterUpdate()
If Forms!complaints1!ECD < Forms!complaints1!ACD Then
DoCmd.OpenForm "acdlate", , , Forms!acdlate!notificationnumber =
Forms!complaints1!notificationnumber, acFormEdit, acDialog
End If
End Sub
When the acd field is updated with a date greater than ecd I see the erro:
"...couldn't find the form "acdlate"...." Spelling is correct. What's going
on?
form acdlate is set up with the border = dialogue and popup = yes.
Any help is appreciated.