How do I make the values of 1 drop-down box dependant on another .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a form that has two drop-down boxes. I want the values
of the second drop-down box to be determined by the values of the first
drop-down box. Any guidance will be very helpful. Thank you/
 
Hi,
The general technique is to use the first combo as criteria in the query that
feeds the second one and requery the second one in the AfterUpdate event of the first.

So in the query that feeds the second, you would have this as criteria for the field
that is common to both:

Forms!yourForm!yourFirstCombo

Then in the AfterUpdate event of the first combo:
Me.secondCombo.Requery
 
Back
Top