A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Look up boxes



 
 
Thread Tools Display Modes
  #1  
Old January 6th, 2010, 01:07 AM posted to microsoft.public.access.tablesdbdesign
chris
external usenet poster
 
Posts: 2,039
Default Look up boxes

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
Ads
  #2  
Old January 6th, 2010, 03: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
  #3  
Old January 6th, 2010, 05:24 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
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


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]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.