I'm surprised it recognizes that in any version.

What is NameThings?

If it's an open form, that should be Forms![NameThings]![NameLOOK]

If it's a table, you need to use a DLookup: DLookup("[NameLOOK]",
"[NameThings]")

If it's a recordset, you need to use NameThings!NameLOOK


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"accessdesigner" wrote in message
...
I purchased a home version of Access from Microsoft through my job, and
when
I tried the following statement using the home version of Access, it wont
recognize [NameThings.NameLOOK] as being correct, but it works at work:
(why?)

Dim strwhere As String
strwhere = ""
If Not IsNull(Me.NameList) Then
If Me.NameList = [NameThings.NameLOOK] Then
strwhere = strwhere & Me.NameList
End If
End If