how do I setup a subcategory lookup based on category selected?

[Brian]

i'm setting up a table which has categories and subcategories. I want to do
both with lookup listboxes in two seperate fields. I created another table
with category and one of its subcategories for a two field table. There are
records for all categories and their subcategories. I have the first lookup
populated with just the categories. I'm having a problem generating a listbox
with just the subcategories for the select category. Any help would be
greatly appreciated.

 

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm