Dlookup Query

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

Guest

Hi

I have two fields on a form.......Suburb and Cit

The suburb is a cboSuburb Quer
In the City field I have =DLookUp("[City] ","[Suburb Query]","[Suburb Query]![Suburb] =" & "[From Suburb]") ( After Update

Suburb Query contains fields Suburb and City

When I select some suburbs the city gets populated but not in others

What have I done wrong

Any help greatly appreciated

Dave
 
Just to add to my question....

If I go to design view and then back to form view it populates all the city fields that have a suburb in the suburb field

Still confuse

Dave
 
I would question why you are storing the value... however
=DLookUp("[City] ","[Suburb Query]","[Suburb] =" & [From Suburb])

--
Duane Hookom
MS Access MVP


Dave Hunt said:
Hi,

I have two fields on a form.......Suburb and City

The suburb is a cboSuburb Query
In the City field I have =DLookUp("[City] ","[Suburb Query]","[Suburb
Click to expand...
Query]![Suburb] =" & "[From Suburb]") ( After Update)
 
Duane

Which value are questioning

If it's the City, it's because I need to cost out delivery costs per destination and there are many suburbs with the same name but are in different cities

Dave
 
I assumed you might be storing a value that can be calculated at any time. I
could be wrong.

--
Duane Hookom
MS Access MVP


Dave Hunt said:
Duane,

Which value are questioning ?

If it's the City, it's because I need to cost out delivery costs per
Click to expand...
destination and there are many suburbs with the same name but are in
different cities.
 
Back
Top