Indicate if a record is present via checkbox

[rodmc]

Small problem that I though would be straight forward, but sods law kicked in and Im at a loss

What Ive got is a main form that has 13 buttons that open up another form for entry/edits, what I want to do is indicate via a checkbox on the main form if there is already a record and thought this would suffice

Private Sub Form_Open(Cancel As Integer)
    If IsNull(DLookup([tblSect1]![RevID], tblSect1, [tblSect1]![RevID] = [ID])) Then
        Check15.Value = False
    Else
        Check15.Value = True
    End If 

End Sub

Keeps telling me that "cant find the field "|" in your expression", any thoughts?

 

[pbaldy]

Let's start by fixing the syntax of the DLookup:

http://www.mvps.org/access/general/gen0018.htm

 

[rodmc]

thanks Paul

Ive changed it to

If IsNull(DLookup("RevID", "tblSect1", "RevID =" & Forms!frmReview!ID))

it now seems to work, can you see anything else that may give me problems?

 

[pbaldy]

No problem, and not offhand.

 

[rodmc]

thanks again Paul