Filter combobox in function of other combobox from the same form
in [Form]
|
Prev: Can a form linked to an autoLookup query update another table
Next: Display a range of dates in a calendar
From: tomcris on 13 Mar 2010 02:04 How I filter value on a combobox function of value of other combo from same forms?
From: John W. Vinson on 13 Mar 2010 11:26
On Fri, 12 Mar 2010 23:04:01 -0800, tomcris <tomcris(a)discussions.microsoft.com> wrote: >How I filter value on a combobox function of value of other combo from same >forms? 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. -- John W. Vinson [MVP] |