"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

There is no "home version" of Access and your syntax is incorrect. When square
brackets are required they need to go around each reference "piece" not around
the outside as you have them.

If Me.NameList = [NameThings].[NameLOOK] Then...

or since your names don't actually require the brackets...

If Me.NameList = NameThings.NameLOOK Then

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com