Very Stressed about Cascading Combo Boxes

[Guest]

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.

 

[John Vinson]

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.

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]

 

[John Vinson]

Thank you for starting from the beginning!

I have created a query for my regions but what about this SQL business? I
have seen this before when trying (and failing!) to play with Events. In the
previous thread, you suggested that I should select just the regions using
the Unique Values property of the query. I didn't find this! I just created a
query with one field from the Areas table. Have I gone wrong already?!

The query grid is a user interface tool for creating SQL. The "real"
Query is not the grid - it's the SQL; and you can post SQL text to a
newsgroup post, while it's difficult and often unreadable to try to
post the query grid. That's why you see SQL getting mentioned often
here!

You can open any query in design view and select the dropdown tool at
the leftmost end of the toolbar. This offers three options: a
datasheet to view the results of the query; Design view, a triangle
and straightedge icon; and SQL.

You can also use the View menu option; using View you can also view
the query's Properties by selecting Properties from the dropdown list.
The Unique Values property is one of these.

Please open the query you're trying to use and copy and paste it to a
message here, if you need help with this. Also indicate what results
you're getting and what results you want.


John W. Vinson[MVP]