Populating List box from selection in Combo Box

  • Thread starter Thread starter nlburgess via AccessMonster.com
  • Start date Start date
N

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?
 
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.
 
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.
Click to expand...
 
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
 
Back
Top