Filter combobox in function of other combobox from the same form

  • Thread starter Thread starter tomcris
  • Start date Start date
T

tomcris

How I filter value on a combobox function of value of other combo from same
forms?
 
How I filter value on a combobox function of value of other combo from same
forms?
Click to expand...

Set the RowSource property of the combo to a Query referencing the other combo
box: use =[Forms]![YourForm]![FirstCombo] as a criterion on the field you want
to filter.

You'll need to Requery the dependent combo in the AfterUpdate event of the
controlling combo.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear Combobox Selection not working 0
Need combo box to refresh when moving to new record 2017 1
Unbound combobox AfterUpdate 5
Filter subform using combobox on main form 1
Update subform with combobox change on main form 1
combobox problem in a simple form!SOS! 3
Combobox Filter 1
filter query on combo box in a continuous subform 0

Back
Top