Access Lookup Postcodes

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

If i have a seperate table that has a list of suburbs and
corresponding postcodes, how can i get the main form to
enter the corresponding postcode from this table when the
suburb is selected. I have related the two tables

Thank you anyone who can assist
 
Hi Roger.

One approach is to use a combo box with 3 columns for the suburb + state +
postcode. However, loading many thousands of suburbs into a combo is less
than ideal. This article explains how to delay-load the combo, so it
contains only the suburbs that match the first 3 characters the user typed.
Once they have typed enough to identify the suburb, the combo's AfterUpdate
event assigns the postcode.

The article is:
Combos with Tens of Thousands of Records
at:
http://members.iinet.net.au/~allenbrowne/ser-32.html
 
Dunno how efficient this is, but this is functionality I use for looking up
customers etc where the user may not know the full name so they can type in
a string which is any part of the name (direct link coz I'm dumb at web
pages):
http://themadbomber.net/Search.mdb
(it already has the aussie post db in it too!)

HTH

Damo
 
Back
Top