- Joined
- Nov 20, 2008
- Messages
- 1
- Reaction score
- 0
I am new to Access (using 2007) so this might be an easy answer. I created a database for a library of pdf files. What I would like to do is create a form to sort the information for easy retrieval. It currently contains serveral combo boxes that work as Conditionals to display the records that me the criteria. The question I have is, how can I set the combo boxes up so that the next combo box used only contains the reduced options.
Example:
My database
1 | A | Z
1 | B | X
2 | B | Y
2 | C | W
if first combo box for Column One is used to select '1', then when Column Two combo box is selected, it only displays the options 'A' and 'B'. Any help that that I can get would be welcome. Thanks. PS. I am only useding 1 Table and 1 Form currently.
Example:
My database
1 | A | Z
1 | B | X
2 | B | Y
2 | C | W
if first combo box for Column One is used to select '1', then when Column Two combo box is selected, it only displays the options 'A' and 'B'. Any help that that I can get would be welcome. Thanks. PS. I am only useding 1 Table and 1 Form currently.