Linked Values?

  • Thread starter Thread starter Helen
  • Start date Start date
H

Helen

Hi All,

Just a query - I am sure that it is possible but can't
think how to do it. I have got a form and a user is going
to input a postcode into a box and in another box, the
corresponding ward should show up.

Does anyone know how to do this?

Many thanks for any help that I get!
 
You can use the DLookup function to place the value in the other textbox.
The other textbox can be a calculated textbox, in which case you would use
the DLookup in its Control Source, or you could use the DLookup in the
AfterUpdate event of the postcode textbox and place the result in the other
textbox. The latter will allow you to bind the other textbox to a
table/query field and will allow the user to changes the result if desired.
Where you live, this may not be a problem, but using the postcode where I
live will return the city that the post office servicing that postcode is
in, which may or may not be the city that the address is actually located
it. It's not a big problem, the mail will get there since it gets to the
correct post office, but it's technically wrong.
 
Back
Top