Selecting from list based on previous entry

[Guest]

Hi,
I am creating a table in MS Access where I would like to use a List Box to
select a value from a list. Unfortunately, I need to change the values in the
List Box based on a previous column in the table. The second column is "Major
Category" and the third column is "Minor Category". I have a list of items
for "Major Category" in another table and a list of items for "Minor
Category" in another table associated with the Major Category.
When I use this statement:
SELECT [Minor Categories].[Minor Category] FROM [Minor Categories] WHERE
(((Questions.[Major Subject])=[Minor Categories].[Major Category]));
I can select the Questions.[Major Subject] from the List Box, but when I go
to open the List Box for Questions.[Minor Subject], Access pops up a Dialog
Box asking for the "Major Subject". It will then generate the correct List
Box for the "Major Category" I type in. Since I will have a large number of
rows to add to the table, I rather not do any extra typing.
Does anyone have an idea why it doesn't work as expected?
Lance

 

[Jeff Boyce]

It sounds as though you are trying to do this in the table. If so, DON'T!

Access tables store data, Access forms (and reports) display data (and help
you look it up).

Is there a chance you are trying to use the "Lookup" data type within the
table? You and Access will both get headaches if you are.

Check the tablesdbdesign newsgroup on the topic of Lookup data types if any
of this fits your situation.

Regards

Jeff Boyce
<Office/Access MVP>