Cascading Combobox

[vsehijpal]

Adjusting Contents of One Combo Box Depending On Selection From Another Combo Box

Hi, first time post (so I hope its in the right place!)

I am building a employee satisfaction survey database where the data is entered through a access built data access web page. Two of the fields that need to be completed are Department and Manager Name. It needs to be designed so that depending on which department you select from a combo box there will be a different list of managers available to select in the Team Manager combo box.

The Department combo box is populated from a Department table and similarly the Manager combo is populated from a Manager table. The two tables are linked in the table relationships so mangers do belong to departments.

My access knowledge is not great so I can populate the two combo boxes ut I dont know how to set the paramters on the data access page so that the contents of the manager combo is dependent on the department one.

Thanks in advance for any help.
Vin

 

[mousemat]

The thing you are looking for is cascading combo boxes. Never bneeded to use them before so not sure how to do it, but have a search for them on here. loads of posts for them

 

[vsehijpal]

Thanks, hopefully its the same for using cascading combo's in access web pages as it is forms.

 

[jfgambit]

You need two comboboxes.

Set the first one to a query that pulls the departments.

Set the second one to a query that pulls the department and the Manager, with the criteria of the department being [Forms]![NameofForm]![DepartmentComboBox].

Then add the following to the After Update event of the Department Combobox:

Me.ManagerCombobox.Requery

You will need to change the names to those in your Db.

HTH

 

[vsehijpal]

Thanks for the help, worked fine on my forms, yet to try it on the web form but there should be similar results.