Microsoft Access 2003 - Form / Combo Box

[EddieL]

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?

 

[Tom Wickerath]

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
__________________________________________

 

[EddieL]

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

 

[Tom Wickerath]

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
__________________________________________