Populating List box from selection in Combo Box

[nlburgess via AccessMonster.com]

I have a form that displays mail date and employer. Mail date is a combo box
populated by a query. What I want to be able to do is populate the employer
list box based on the selection from the mail date combo box. I want the
List to re-populate everytime a different date is chosen from the mail date
combo box. Any suggestions other than using two forms?

 

[Klatuu]

The row source of the list box should use the value of the combo box for
filtering. Then in the After Update event of the combo, requery the list box.

 

[nlburgess via AccessMonster.com]

How exactly do I do this? Do I need a Macro?

The row source of the list box should use the value of the combo box for
filtering. Then in the After Update event of the combo, requery the list box.

 

[Klatuu]

I would use VBA.

First the row source of the list box has to reference the value in the combo
box:

Select AField, AnotherField FROM SomeTable WHERE AField = Me.MyCombo

Then in the After update event of the comb:

Me.MyListBox.Requery