when i used ......If Me.NameList = [NameThings].[NameLOOK] Then... an error
message read .....MS ACCESS CAN'T FIND THE FIELD 'l' REFERRED IN YOUR
EXPRESSION

when i used ..... If Me.NameList = NameThings.NameLOOK Then...an error
message read... OBJECT REQUIRED

when i said home version of MS Access... its a version of MS software that
MS allows employees of other companies, such as mine, to purchase for home
use.... (Microsoft Home Use Program,... this product is not for resale)



"Rick Brandt" wrote:

"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