Hey guys. I'm new to Access, and new here. I was assigned a project at work and it requires me to create a database, and an application for end users with Access. I'm already running into some issues. The application is going to be used for weekly assessments. It needs to include checklists for assessing multiple areas of multiple buildings.
What I'd like to do:
I have a small understanding of how the Lookup Wizard works. When creating my first table, I used it to create a drop down box that allows the user to choose what building they are assessing. Here's where the trouble comes; once the user chooses what building they're in, they'll need to then choose what area of the building they are assessing. What I'd like to do is create a look up or a macro that only updates the areas of the building that the user just selected.
For instance:
The sections are all numbered or named differently for each building. So the areas in "Building A" are called "Area 1", Area 2, etc. For Building B, every area is called "Section 1-101", or "Section 1-102". When the user selects Building A, can I build a macro or something that only updates areas in building A. So that when the user chooses a specific building, only the areas in that specific building appear as options in the next field. And can this be done for multiple buildings? Does that even make sense?
Any help would be appreciated,
Thanks
What I'd like to do:
I have a small understanding of how the Lookup Wizard works. When creating my first table, I used it to create a drop down box that allows the user to choose what building they are assessing. Here's where the trouble comes; once the user chooses what building they're in, they'll need to then choose what area of the building they are assessing. What I'd like to do is create a look up or a macro that only updates the areas of the building that the user just selected.
For instance:
The sections are all numbered or named differently for each building. So the areas in "Building A" are called "Area 1", Area 2, etc. For Building B, every area is called "Section 1-101", or "Section 1-102". When the user selects Building A, can I build a macro or something that only updates areas in building A. So that when the user chooses a specific building, only the areas in that specific building appear as options in the next field. And can this be done for multiple buildings? Does that even make sense?
Any help would be appreciated,
Thanks