 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008Microsoft Access 2003 - Form / Combo Box
I am trying to develop a form that does the follow in Access 2003: Allows me to populate the underlying query which in turn populates a table. I wish to allow the user to select the data to be inputted using a combo box on the form. The data is in 3 levels i.e. Level 1 is Section, Level 2 is element of that section and Level 3 is a sub-element. The form terefore will have 3 combo boxes. Once the user has selected the Level 1 I need level 2 data to be restricted to that relevant to the choice in the Level 1 combo box? Any help? Hi Eddie, See this KB article: How to synchronize two combo boxes on a form http://support.microsoft.com/?id=289670 Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ > I am trying to develop a form that does the follow in Access 2003: > [quoted text clipped - 7 lines] > Once the user has selected the Level 1 I need level 2 data to be restricted > to that relevant to the choice in the Level 1 combo box? Any help? Tom, Thank you for that. Unfortunately, the link does not explain how to reference the form to underlying tables fromm which I want to select the data. The Northwind database for me, is relatively complex and trying to follow it through is impossible. Pleasse can you give an idiots guide to do the task? Thanks > I am trying to develop a form that does the follow in Access 2003: > [quoted text clipped - 7 lines] > Once the user has selected the Level 1 I need level 2 data to be restricted > to that relevant to the choice in the Level 1 combo box? Any help? Hi Eddie, > Thank you for that. Unfortunately, the link does not explain how to > reference the form to underlying tables from which I want to select the > data. The example uses an unbound form, probalby because they just wanted to keep it simple. However, there's nothing preventing you from assigning a recordsource to the form. > Pleasse can you give an idiots guide to do the task? Before I try to do that, I'd like to know if you even tried the KB article example on a copy of Northwind. If you haven't tried it yet, then I think it's premature to be asking for more help. If you have tried it, and got stuck, then identify the exact step in the KB article that you either don't understand, or is giving you problems. Here is another example that you might find more to your liking: Limit content of combo/list boxes http://www.mvps.org/access/forms/frm0028.htm Check this site out in a few days: http://www.seattleaccess.org/downloads.htm There should be a new sample posted anytime now. One of our regular members named Laurie gave a presentation last night (5/13/08) on combo boxes. Her presentation included an example of how she does synchronized combo boxes. Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ > Tom, > [quoted text clipped - 6 lines] > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.