Microsoft Access: Using Checkboxes on Form to Determine/Summarize Options in Combo box/Drop down on Different Form
[NOT FINISHED. Couldn't save as draft so only option was to upload] I have a form for entering material types and the main data entry form. On the main data entry form we have a combo box/drop down of tasks and materials. We only use certain materials for certain tasks, so I want to reduce the combo box based on my selection. I have only 8 tasks and over 20 materials; so it makes sense for me to put the task selections with the materials form Record Source: tbl_materials Form Type: Single Form Added Task 11 and task 12 as extra (blank) just in case we add more tasks Combo_task_type_AfterUpdate() If Me.Combo_task_type = 1 Then Me.combo_materials.RowSource = "SELECT material_id,material_type,status_id,task1 FROM tbl_materials WHERE task1= True ORDER BY tbl_materials.material_type;" Me.combo_materials.Requery End Sub
