Category & Sub-Catergory selection

[Guest]

This is simple stuff but I can’t get my head around it!
Within a table I want two Fields: Category and Subcategory.
I want to be able to select the Category from the first field in a combo box
then the relevant sub category to appear in the Subcategory box. Can anyone
point me in the right direction for starters ?

 

[Guest]

Go to www.microsoft.com and search on item number 289670 this will give
the codes you need

 

[Douglas J Steele]

Rather than having to search, you can go directly to
http://support.microsoft.com/?kbid=289670 <g>

 

[Guest]

Had a look at that and also at
http://www.databasedev.co.uk/filter_combo_boxes.html.

This seems to work OK for filtering the results of the second combo-box but
I cant relate this to then being able to adding my selected Category and
Subcategory to my table.

The objective was to be able to create a record with a Category from a
dropdown then choose a subcategory from a dropdown that was filtered by the
selection made in category.

If my basic table looks like:

Complaint ID (Primary Key)
Name:
Category:
Sub-Category:
Notes:

I think what im asking is how do I get the results of the selection in the
Form and combo boxes to populate my table.

This probably does not make any sense but its worth a try anyway!