Okay... too much emphasis on the use of the word home version... through my
job, I purchased the right to use MS Access on my home computer.. they mailed
me the software...im using it at home. however, when i practice using Access
at home, the same thing I did at work, doesnt work here at home...

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

Im trying to get a combobox selection from a form to match what is in my
query named NameThings, under the NameLOOK field...

"ruralguy via AccessMonster.com" wrote:

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