Populating a combo box depending on the selection of another combo

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!!
 
F

fredg

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populating a combo box with values depending on another Drop Down 12
Forms in Access - Auto populating fields 12
Combo Box Selection 1
Populating Combo Box after another combo box has been selected 8
Combo Box with multiple selection in text boxes 7
Linking combo box to another 8
Filter Combo Box B based on Combo Box A Selection 4
Filtering combo boxes based on a selection in another combo box 1

Top