Limiting Choices in Access

[EricaP]

Hello Everyone,

I am trying to figure out how to limit choices based on a previous choice made in Access. Here is what I mean:

I am creating a database that tracks events. Each type of event falls under a specific heading. I have called this HeadingID. There are 24 different Headings. Now, I would like the user, depending on which Heading he chooses, to only have access to the specific subheadings that go with it. There are about 5-25 subheadings per Heading.

I'm not sure how to go about limiting this choice. I don't want the user to have access to ALL subheadings, just the ones that are specific to the Heading they had previously picked from a combo box drop down menu in the previous field. Any ideas??

 

[EricaP]

Sorry, this is Access 2010.

 

[jdraw]

I think you are talking about Cascading Combos. There are free video tutorials at

http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html


But I strongly recommend you get a clear understanding of your business rules and design your database before getting too deep into Access things.

Tutorial to help with design at
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

 

[EricaP]

Thanks! Cascading Combo boxes is exactly what I want!!