using combo box to select criteria

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I have a form containing two combo boxes. I would like
the first combo box to filter out results to display in
the second combo box. Is there a relatively simple way
to do this? Thanks.
 
The usual way is to compose the RowSource SQL for the
second comboBox in the first combo's AfterUpdate
eventHandler e.g.
combo2.RowSource = "SELECT ... FROM ... WHERE aColumn = '"
& combo1.Value & "'"

If the combo1 value is a number, you omit the surrounding
single quotes.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top