Dlookup help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have looked at all the examples and read through many threads and can't
figure out what I am doing wrong. I have a form based upone a table called
"Controls". I want to lookup a value called "TPLong" in a table called
"TopPDetail" based upon TopPDetails field "TPShort". In trying to do this I
tried to hard code the criteria but can't even get that to work. Below is
the hard keyed version from the Expression Builder. There is a TPshort field
with "EQ" in it, but the field just remains blank on the field. After I get
this to work I will adjust for the value on the field.

=DLookUp("[TPLong]","TopPDetail","[TPShort] = 'EQ'")

Thanks for the help!
Dave
 
=DLookUp("[TPLong]","TopPDetail","[TPShort] = ' " & me.TPShort & " ' " )

=DLookUp("[TPLong]","TopPDetail","[TPShort] = ""EQ""")


|I have looked at all the examples and read through many threads and can't
| figure out what I am doing wrong. I have a form based upone a table called
| "Controls". I want to lookup a value called "TPLong" in a table called
| "TopPDetail" based upon TopPDetails field "TPShort". In trying to do this I
| tried to hard code the criteria but can't even get that to work. Below is
| the hard keyed version from the Expression Builder. There is a TPshort field
| with "EQ" in it, but the field just remains blank on the field. After I get
| this to work I will adjust for the value on the field.
|
| =DLookUp("[TPLong]","TopPDetail","[TPShort] = 'EQ'")
|
| Thanks for the help!
| Dave
 
Back
Top