Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-03-2011, 07:56 AM   #1
ds3010
Newly Registered User
 
Join Date: Nov 2011
Posts: 5
Thanks: 3
Thanked 0 Times in 0 Posts
ds3010 is on a distinguished road
Lookup List of Values depending on a previous lookup list

Hello, I'm completely new to Access so this might sound a little too newbee for you. Well, here it goes. I'm creating a simple database for a competition. Participants are awarded points every time they do a certain volunteer job. My fields are the ID primary key, Last Name, First Name, Volunteer Job, Participation, Date and Points Earned. The Volunteer Job Field is a list of look-up values that I just created.

The issue is that "participation" should be a list of values but they directly depend on the volunteer job. This is that for example if I scroll down the Volunteer Job option and I choose let's say: "Newspaper", I want the "Participation" field to automatically show another look-up list with "Wrote an article; provided a tip for an article; volunteered for one hour". And every time I choose a different Volunteer Job from the drop-down list I created, the "Participation" field should show the appropriate list of options depending on the Job I chose.

Any ideas would be very appreciated thanks.
P.D: I'm not that much into SQL, so if the solution is typing commands in the row source property please help me out.

Best Regards

ds3010 is offline   Reply With Quote
Old 11-03-2011, 08:04 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,126
Thanks: 13
Thanked 4,078 Times in 4,013 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Lookup List of Values depending on a previous lookup list

Sounds like this:

http://www.baldyweb.com/CascadingCombo.htm
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
ds3010 (11-07-2011)
Old 11-03-2011, 08:07 AM   #3
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,142
Thanks: 81
Thanked 2,010 Times in 1,958 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Lookup List of Values depending on a previous lookup list

You shouldn't use lookups at the table level.
http://www.mvps.org/access/lookupfields.htm

If that isn't what you're doing, you may want to search for Cascading Comboboxes which is what I think you're asking about.

jdraw is offline   Reply With Quote
The Following User Says Thank You to jdraw For This Useful Post:
ds3010 (11-07-2011)
Old 11-03-2011, 08:35 AM   #4
ds3010
Newly Registered User
 
Join Date: Nov 2011
Posts: 5
Thanks: 3
Thanked 0 Times in 0 Posts
ds3010 is on a distinguished road
Re: Lookup List of Values depending on a previous lookup list

Cascading Combo Boxes!!! that's exactly what I'm looking for!!! thank you that's a great start. Now I will start looking up through the internet and learn how to do it. If you could please send me good links about that so I can understand how to do it that'd be awesome. Thanks again.
ds3010 is offline   Reply With Quote
Old 11-03-2011, 08:36 AM   #5
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,126
Thanks: 13
Thanked 4,078 Times in 4,013 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Lookup List of Values depending on a previous lookup list

Did my link not work?
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
ds3010 (11-07-2011)
Old 11-07-2011, 07:39 AM   #6
ds3010
Newly Registered User
 
Join Date: Nov 2011
Posts: 5
Thanks: 3
Thanked 0 Times in 0 Posts
ds3010 is on a distinguished road
Re: Lookup List of Values depending on a previous lookup list

Thanks guys
ds3010 is offline   Reply With Quote
Old 11-07-2011, 08:35 AM   #7
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,126
Thanks: 13
Thanked 4,078 Times in 4,013 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Lookup List of Values depending on a previous lookup list

Happy to help.


__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically list values from lookup list HVACMAN24 Tables 4 02-22-2011 04:12 AM
Lookup list BCote689 Queries 7 02-05-2009 01:52 PM
Lookup Box List Box ?? GOSLINC Forms 1 12-01-2006 06:39 AM
Lookup List Brutal Forms 10 06-15-2003 08:51 PM
need lookup list? lilakathy Forms 1 08-12-2002 03:23 AM




All times are GMT -8. The time now is 06:32 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World