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