If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007 - "if-then" rules for selecting lists in a form?
In my museum operations database, I have 190 exhibits, in 27 galleries, at 2
locations. I would like help in setting up a form so that I can select an exhibit by starting at lthe ocation, then going to galleries, then exhibits. For example instead of scrollling through a list of 190 possible exhibits, I would like to select location A, then when I tab over to galleries, only galleries in location A are possible in a pull down list, then if I select gallery 5, then only the 12 exhibits in gallery 5 are possible in a pull down list. IS this possilbe in Access? How is this hierachy done? Thank you. |
#2
|
|||
|
|||
Access 2007 - "if-then" rules for selecting lists in a form?
Yes, it is possible.
Examle is included Alex |
#4
|
|||
|
|||
Access 2007 - "if-then" rules for selecting lists in a form?
yes - this probably is not the only way, and not sure how you have your
form(s) set up, but i have set up a series of combo boxes. after you select the first level (i.e. location), the next level (i.e. galleries) is based on a query that is filtered by the object that the user has selected in the first combo box. The exhibits combo box query would be filtered on what the user selects from the galleries combo box. the syntax in your query's filter to refer to the previous combo box is as follows: [forms]![NameofForm]![NameofPreviousComboBox] you should also set each combo box to "requery" in the On Got Focus property so that it will rerun and pick up the most recently selected choice each time. "Director of Exhibits" wrote: In my museum operations database, I have 190 exhibits, in 27 galleries, at 2 locations. I would like help in setting up a form so that I can select an exhibit by starting at lthe ocation, then going to galleries, then exhibits. For example instead of scrollling through a list of 190 possible exhibits, I would like to select location A, then when I tab over to galleries, only galleries in location A are possible in a pull down list, then if I select gallery 5, then only the 12 exhibits in gallery 5 are possible in a pull down list. IS this possilbe in Access? How is this hierachy done? Thank you. |
Thread Tools | |
Display Modes | |
|
|