Combo Box Selection

[Eranka]

Hi

I have created two combo boxes in my access form.

Combobox1 = Employee_ID (Employee Table)


Combobox2 = Employee_Working_Department (Department table)

When i click on the 1st combobox and select an employee the second combo box should show the departments that he working. (If an employee works in IT and HR the second combo should show only IT and HR). How to do this?

***With my current form when i select an employee it shows all the department in the company instead of showing IT and HR***

[ranman256]

The form should be connected to Employee table,
there should be a text box connected to EmpID field, (and all other Employee fields)
the form header should have an unbound combo box with the EmpIDs to filter

once you pick combo EmpID, filter the record to show that 1 employee. The combo box will filter too.

sub cboEmpID_afterupdate()
if isNull(cboEmpID) then
   me.filterOn = false
else
   me.filter = "[EmpID]=" & cboEmpID 
   me.filterOn = true
end if
end sub

[ssanfu]

The Row Source for Combobox2 should have a WHERE condition that references Combobox1 and a little VBA code to requery.

Tear apart the attached example dB.
IIRC, it has 7 cascading combo boxes.

Also, there is a cascading list box example (to see all options at once).

[Eranka]

Hi ssanfu

How did you hide the tables and forms on the side and display the main menu when program opens?

[isladogs]

As I'm online, I'll answer for ssanfu.

Go to File ...Options ... Current Database
The 2 items I've highlighted load a specified form & hide the navigation pane