filter list box with a combo box

  • Thread starter Thread starter Gary Hull
  • Start date Start date
G

Gary Hull

I have a form with a combo Box in the main form that selects a record

In the sub form I have a list box that selects a record on the sub form

What I need to do is to have the list box to be filtered according what is

selected with the combo box on the main form
 
In the AfterUpdate event of the combo on the main form requery the list box:

Me.SubformControlName.Form.Requery

Set the criteria of the list box to:

[Forms]![MainFormName]![ComboBoxName]
 
Back
Top