Jump to content

SELECT problem

Recommended Posts

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

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...