Error 2465 - can't find the field "¦" referred to in your expression.

[ajc123]

How does Access come up with the field "|" from the expression:

Private Sub Child2189_Enter()
If IsNull([PCOs/COs]!IssueDate) Or [PCOs/COs]!IssueDate = "" Then
Me.AllowEdits = True
Me.AllowAdditions = True
Else
Me.AllowEdits = False
Me.AllowAdditions = False
End If

End Sub

Where [PCOs/COs] is the parent form.
IssueDate is a field on the form.

Is there a preferred way to check criteria on the parent form?

Thanks,

Avery.

 

[KennyUK]

Hey Avery,

One thing you could try is an explicit reference to the forms like so:

If IsNull([Forms!PCOs!form!COs]!IssueDate) Or [Forms!PCOs!form!COs]!IssueDate = "" Then

Only a suggestion but worth a try.

Good Luck

KennyUK

 

[tlbroadbent]

Refer to the complete form name.

IsNull(Forms![PCOs/COs]!IssueDate)

Or

If Child2189 is a control on the [PCOs/COs] form you can just use the keyword Me to refer ro the form.

IsNull(Me.IssueDate) Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.