>I have a group of combo controls in a container object that I've saved as a class. The group of controls provide descriptive attributes for each record in my table. Since all the controls have the controlsource (view) in common, I would like to be able to set a single class property I've added called ControlSourcePrefix and have my init code add this suffix to all the controlsouces instead of having to reset each one individually when I add this class to a form with a different controlsource (view).
>Would anyone have a code sample for setting a group of control's controlsource property replaced with the ControlSourcePrefix + controlsouce.
>For example:
> ControlSourcePrefix=v_AccountMaster
>cboCity.controlsource=cityiid -------------> v_AccountMaster.cityiid
>cboDistrict.controlsource=districtiid -----> v_AccountMaster.districtiid
>cboDepartment.controlsouce=departmentii ---> v_AccountMaster.departmentiid
>
>Thank you,
>
>Gary Pike

If you haven't already, check out the FOR EACH ... IN ... construct.