Drop down boxes

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi,

I am trying to figure how to display a drop down box in a form, and when
something is selected from that drop down box, that another corresponding
drop down box appears with the options available from the original selection.
Does anyone know how to do this???
 
Hi,

I am trying to figure how to display a drop down box in a form, and when
something is selected from that drop down box, that another corresponding
drop down box appears with the options available from the original selection.
Does anyone know how to do this???
Click to expand...

Leave the rowsource of the 2nd combo box blank.
Code the AfterUpdate event of the 1st combo box to fill the rowsource
of the 2nd.
Something like this:
Combo2.Rowsource = "Select Instructors.InstructorID,
Instructors.InstructorName from Instructors Where Instructors.ClassID
= " & Me!ComboName & ";"

Change the table and field names as needed.
The above assumes ClassID is a Number datatype and the combo box bound
column is Number also.
 
Back
Top