	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 > Combo Box

Using MS Access - Combo Box

Expert: Richard Rost - 7/8/2009

Question
I currently trying to make two combo boxes synchonize where one updates based on the selection from the previous. I'm using the source code beneath but when I run the form the second box shows as blank. Is there a different way to accomplish this goal or is there something wrong with my programming?

Private Sub txtAreaSearch_AfterUpdate()
Me.txtBuildingSearch.RowSource = "SELECT Building FROM" & _
" [qry Building Name] WHERE AreaName = " & _
Me.txtAreaSearch & _
" ORDER BY Building"
Me.txtBuildingSearch = Me.txtBuildingSearch.ItemData(0)
End Sub

Answer
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

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