I have 2 tables one have grades 5-8 and the other have sections for each grade. I want after selecting the grades from first combo box to update the data in the second combo box to have the values of the sections for the grade selected.
I have 2 tables one have grades 5-8 and the other have sections for each grade. I want after selecting the grades from first combo box to update the data in the second combo box to have the values of the sections for the grade selected.
combo 2 query looks at combo1 for criteria:
select * from table where [field]=forms!myForm!cbo1
so when user picks combo1, just refresh cbo2:
Code:sub cboBox1_afterupdate() combo2.requery end sub
The topic/concept you are describing is known as Cascading Comboboxes.
There are several youtube videos on the subject.