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
|