	AllExperts > Using MS Access
	Search

About Richard Rost
Expertise

I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.

Experience
I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com

You are here: Experts > Computing/Technology > Business Software > Using MS Access > Drop Down List/Look Up Table Question

Using MS Access - Drop Down List/Look Up Table Question

Expert: Richard Rost - 10/30/2009

Question
Hi Richard

I was wondering of you could help me.I have had some experience with access and would say that I am at intermediate, but have not used access for a while. I am working with Access 2007.

I am creating a time management database. I have a Look up table called Activity and would like another called Activity Detail. I would like the Activity Detail table to display certain criteria dependant on what is selected in the Activity table for example selecting 'Typing' from the Activity Table would then display 'Letter', 'Report', etc in the Activity Detail table. Is this possible and can you advise on how to do this?

Thanks in advance
Amy Smith

Answer
If I understand you correctly, you want to select a value in one combo box and have the values in the second combo box change based on the first value selected. If so, this tutorial should answer your question:

I get asked this question all the time. You've got two or more combo boxes and you want the first one to filter the second one. I get asked this so much that I recorded a video tutorial explaining how to do it:

http://599cd.com/tips/access/two-combo-boxes?key=AllExperts

Let me know if you have any other questions or comments.

Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts

Cordially,

Richard Rost
599CD Computer Training
http://www.599cd.com

P.S. Also, don't forget to visit my FREE Microsoft Access Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts

P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.

http://www.599cd.com/Microsoft_Access_Tutorial?key=AllExperts

I hope this information helps to solve your problem. If there is ANY REASON why you won't give me a RATING of 10 please let me know so I can improve upon my answers in the future. Thank you!

Sign up for my FREE NEWSLETTER with lots of TIPS and TRICKS. Visit http://www.599cd.com/MailingList?key=AllExperts

Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=AllExperts

Add to this Answer Ask a Question