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

B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Category and Subcategory 4
Filter lookup based on field value in current record 3
How do I create a click on + symbol to open a root and click on -. 1
Building cascading lookups in an Access 2007 table 1
Using form values in query statement 1
Linking Data on a Form in Access 2000 1
Problem with stacked column chart 5
Combining category and subcategory 5

Top