ty... ( need you all on speed dial.... lol)

my combobox is connected to :
SELECT Names.Name FROM [Names] ORDER BY [Name];
(thats a table where my list names scroll down from the combobox

The Query: NameThings .....is only connected to my Report

"ruralguy via AccessMonster.com" wrote:

Sorry to pound on you for the "Home Version" thing. Thankfully, Granny set
us all straight. Is the query NameThings bound to your form?

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

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
[quoted text clipped - 21 lines]
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 AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1