Thread: Look up boxes
View Single Post
  #2  
Old January 6th, 2010, 04:26 AM posted to microsoft.public.access.tablesdbdesign
fredg
external usenet poster
 
Posts: 4,386
Default Look up boxes

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


Using unbound text controls, set their control source to:
=[ComboName].Column(1)
=[ComboName].Column(2)
etc.
Combo boxes are zero based, so Column(1) is actually the second
column.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail