On Tue, 5 Jan 2010 17:07:01 -0800, Chris
wrote:

I have created a look up table and the fields are SuburbID (primary key)
Suburb, State, District, Map Ref.

Then I have created a form that allows me to put in addresses of companies
and my question is - how can I, on this form, select the suburb from a drop
down box and it automatically comes up with the state, district and map ref
in three separate boxes so I don't have to enter this information.

Thanks

The state, district, and map should simply NOT EXIST in any table other than
the Suburb table.

Just store the SuburbID, and use a Query linking to the Suburb table to look
up these values. That query can be used as the recordsource of a Report (to
print the address information, say).

Fred's suggestion will let you display (but not store) these fields on your
form. That's the correct approach.
--

John W. Vinson [MVP]