Syntax error with DLookUp()

[shylock]

I have a table titled "IPAddress". One of the fields is "IP" defined as short text. This table contains IP Addresses that exist for our servers. Before adding a new IP Address to the table, I want to make sure that the IP I am adding doesn't already exist in the table. I am using DLookUp() to determine this. My code is:

Lvar = DLookup("[IP]", "IPAddress", "[IPAddress].[IP] = " & NewIP)

Lvar is Dimmed as a variant, NewIP is dimmed as a string. I am getting the following error: "Run-time error '3075: Syntax error in number in query expression "'[IPAddress].[IP] = 140.106.55.351'. I should also mention that NewIP is being used in the Append Query and works fine. I have also tried the DLookUp with just "[IP] = " & NewIP) and get the same error.

Can anyone help?

[shylock]

Never mind... I have already solved this one. My modified code:

    If IsNull(DLookup("IP", "IPAddress", "[IPAddress].IP = '" & NewIP & "'")) Then
        ''' Insert the new IP Address
        DoCmd.RunSQL "INSERT INTO IPAddress (IP, IPType, FriendlyName, Ports) VALUES" & _
        "('" & NewIP & "', '" & NewIPType & "', '" & NewFNm & "', '" & NewPort & "')"
        
        ''' Close the frmNewIPAdr and return to frmIPAddresses
        DoCmd.Close acForm, "frmNewIPAdr", acSaveNo
    Else
        ''' The IP Address already exists display a message and exit the form
        myMsg = MsgBox("The IP Address already exists.  Enter a better IP!", vbInformation, "IP Already Exists")
        DoCmd.CancelEvent
        Me.txtNewIPAdr.SetFocus
        Exit Sub
    End If

Works perfectly.