Very Stressed about Cascading Combo Boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KateAccess - 12 Apr 2005 15:58 GMT

I have posted a similar query to this and I have attempted to follow the
suggestions but I have had no luck.

Here's the situation: I have ONE table and a form based on it. Two of the
fields in this are called Region and Area. Region has a combo box containing
regions in the UK (North West, North East etc). Area has a combo box
containing names of counties in all of the regions.

Question: Is there an EASY way to limit the options of the Area combo box
when a certain region is selected in the Region combo box?

I have had a look on MS Assistance and they even have a detailed description
of how to do the exact thing that I want. However, it involves queries and
tables and as I said, I only have one at the moment!

I have no VB programming knowledge whatsoever.

Reply to this Message

John Vinson - 12 Apr 2005 18:21 GMT

>I have posted a similar query to this and I have attempted to follow the
>suggestions but I have had no luck.
[quoted text clipped - 12 lines]
>
>I have no VB programming knowledge whatsoever.

If you want to see a list of regions and the areas within those
regions...

Then you need a table of regions and the areas within those regions.

Access isn't magical. It doesn't know which Counties are within the
North West. (I don't either, for that matter; I'm a Colonial living in
the Wild West).

Create a table Areas with two fields - Region and Area, if that's what
you want them named. Base your combo boxes on this table, not on your
main table, and not on value lists. The instructions I posted
yesterday will now maybe make a bit more sense!

John W. Vinson[MVP]

Reply to this Message