DLookup issue

[aquinox]

Hi,

I got a problem with DLookup. I'm using Access 2003.

Here is the code

In the form, i have a combo-box that has a list of towns.

the following is the code that i put in the control-Source of a textbox that shows the result of DLookup.

In the control-source,
=DLookup("MaryTime","Locations","Location" = Forms![Pump Stations]!Location)

This returned nothing.

MaryTime is of type "Text"
Location (of Locations table) is of type "Text"

But when i put this into SQL query, it returns the value of MaryTime.

Look forward to hearing from you.

Thank you

 

[PHV]

You may try this:

=DLookup("MaryTime","Locations","Location='" & Forms![Pump Stations]!Location & "'")

or this:

=DLookup("MaryTime","Locations","Location=Forms![Pump Stations]!Location")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aquinox]

Hi PHV,

Thank you, you're a legend.