Filtering Combo box

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

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.
 
Back
Top