Dlookup Expression Error

  • Thread starter Thread starter Pamela
  • Start date Start date
P

Pamela

My query is based on a table that I use to populate a cbo on a form. My
table includes: ID(pk), ShopName, and ShopCity (which stores the ID # from
tblCity). My query has ShopName, ShopCity and an Expression field that I was
to use later. Everything in my expression works except for the DLookup which
is just blank.

Expr1: IIf([ShopName]="None","The owner did not have a choice of shop at the
time of my inspection.","The owner has chosen " & [ShopName] & " in " &
DLookUp("[City]","[ltblCity]","[CityID]"="[ShopCity]"))

Please help me to see what's wrong with this expression. Again, not getting
an error - but just a blank where that City name should be.

Thanks!
 
My query is based on a table that I use to populate a cbo on a form. My
table includes: ID(pk), ShopName, and ShopCity (which stores the ID # from
tblCity). My query has ShopName, ShopCity and an Expression field that I was
to use later. Everything in my expression works except for the DLookup which
is just blank.

Expr1: IIf([ShopName]="None","The owner did not have a choice of shop at the
time of my inspection.","The owner has chosen " & [ShopName] & " in " &
DLookUp("[City]","[ltblCity]","[CityID]"="[ShopCity]"))

Please help me to see what's wrong with this expression. Again, not getting
an error - but just a blank where that City name should be.

Thanks!
Click to expand...

This will return the value of City where the CityID is the literal text string
"[ShopCity]". I very much doubt there is such a record!

Try

Expr1: IIf([ShopName]="None","The owner did not have a choice of shop at the
time of my inspection.","The owner has chosen " & [ShopName] & " in " &
DLookUp("[City]","[ltblCity]","[CityID]=" & [ShopCity]))

This will concatenate the *value* (presumably a number) of ShopCity to the
text string "[CityID] =" giving a result like

[CityID] = 3198

or whatever the shopcity value might be.
 
That did it! Thank you so much!

John W. Vinson said:
My query is based on a table that I use to populate a cbo on a form. My
table includes: ID(pk), ShopName, and ShopCity (which stores the ID # from
tblCity). My query has ShopName, ShopCity and an Expression field that I was
to use later. Everything in my expression works except for the DLookup which
is just blank.

Expr1: IIf([ShopName]="None","The owner did not have a choice of shop at the
time of my inspection.","The owner has chosen " & [ShopName] & " in " &
DLookUp("[City]","[ltblCity]","[CityID]"="[ShopCity]"))

Please help me to see what's wrong with this expression. Again, not getting
an error - but just a blank where that City name should be.

Thanks!
Click to expand...

This will return the value of City where the CityID is the literal text string
"[ShopCity]". I very much doubt there is such a record!

Try

Expr1: IIf([ShopName]="None","The owner did not have a choice of shop at the
time of my inspection.","The owner has chosen " & [ShopName] & " in " &
DLookUp("[City]","[ltblCity]","[CityID]=" & [ShopCity]))

This will concatenate the *value* (presumably a number) of ShopCity to the
text string "[CityID] =" giving a result like

[CityID] = 3198

or whatever the shopcity value might be.
--

John W. Vinson [MVP]

.
Click to expand...
 
Back
Top