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

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.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Brian" wrote in message
...
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.