I don't know what a "Home Version" of Access could possible be other than a
retail version of Access. It is probably a later version than you are using
at work. Each version released was a little less forgiving that the prior
version. I believe the correct syntax is:

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

If [NameThings] is the name of a table bound to the form you are working on
then I think:

If Me.NameList = [NameLOOK] Then

...will work as well.

accessdesigner wrote:
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

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com