autofill a text box with value from lookup table

[Satyakrishna das]

if I had a lookup table 'postlook' with fields: city and
postcode with data such as Kailua 96734, Honolulu 96108,
Kaneohe 98001, etc. Then on a form, every time I entered a
city name and exited out of that text box, the text box of
postcode would automatically fill in with the value from
the lookup table? by the way, the form that data is
getting entered into is related to a different table than
the lookup one

 

[Allen Browne]

Use DLookup() in the AfterUpdate event of th text box to look up the value
and assign it to the postcode control.

For help with DLookup(), see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html