Populating a combo box depending on the selection of another combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a form to tracking overtime hours for a police department.
Part of the form asks for the section and the position of the worker. The
department is broken up into three sections, housing, booking, and control.
Under each of these sections, there are various positions that can be worked.

I currently have two tables related to this aspect of the process. The
section table has a sectionID and a sectionname for the three sections plus a
misc. section. After one of these items is selected from cboSection, I want
cboPosition to autopopulate with only those positions under that section. The
positions are located in a positionbysection table, where there is an ID and
section associated with all positions. i.e. below

-----------------------
ID Sec. Pos.
1 Booking A2
2 Booking 12
3 Housing B4
4 Control watch

Therefore, how do i make such a thing happen, where the cboPosition
autopopulates after a value from cboSection has been selected? Thank you in
advance!!
 
I am working on a form to tracking overtime hours for a police department.
Part of the form asks for the section and the position of the worker. The
department is broken up into three sections, housing, booking, and control.
Under each of these sections, there are various positions that can be worked.

I currently have two tables related to this aspect of the process. The
section table has a sectionID and a sectionname for the three sections plus a
misc. section. After one of these items is selected from cboSection, I want
cboPosition to autopopulate with only those positions under that section. The
positions are located in a positionbysection table, where there is an ID and
section associated with all positions. i.e. below

-----------------------
ID Sec. Pos.
1 Booking A2
2 Booking 12
3 Housing B4
4 Control watch

Therefore, how do i make such a thing happen, where the cboPosition
autopopulates after a value from cboSection has been selected? Thank you in
advance!!
Click to expand...

See:
http://www.mvps.org/access/forms/frm0028.htm
 
Back
Top