Constrain List Box based upon results from another control

[MackBlale]

I have created a form to input data into tblEmployees. On the
frmEmployeeData I have created a List Box that gives a choice of 5 regional
centers. Each of these centers has between 5 and 15 sites. I want to create
another list box that will constrain the choices to specific sites based upon
which center is chosen by the list box ctrHandlingCtr.

Thanks

 

[bhicks11 via AccessMonster.com]

Put the reference to ctrHandlingCtr in your datasource query for the list box.
Make sure you requery after selecting the option in the ctrHandlingCtr.

Bonnie
http://www.dataplus-svc.com

 

[bhicks11 via AccessMonster.com]

Put the reference to ctrHandlingCtr in your datasource query for the list box.
Make sure you requery after selecting the option in the ctrHandlingCtr.

Bonnie
http://www.dataplus-svc.com

 

[MackBlale]

I should have said "Combo Box" Does it matter. And I need step by step
instructions as I am not that familiar with Access and my "Access Bible"
hasn't arrived to Iraq yet. Thanks
Mac