Filtering Combo box

[Jeff Klein]

I have a form with two combo boxes. The first combo box shows a list of
"Programs" obtained from "tbl_Programs". The second combo box lists
"ProcedureCodes" that are obtained from tbl_ProcedureCodes.
OK...Some ProcedureCodes are not applicable to certain Programs. How can I
limit the list in the ProcedureCodes combo box depending on what has been
picked in the Program combo box? I know how to hard-code this but I need a
way to pick the Procedure Codes that relate to the Programs. Any Ideas.

 

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm