filter listbox values

  • Thread starter Thread starter Gavin
  • Start date Start date
G

Gavin

Hi could someone explain how i can filter a listbox's
values based on the value selected in a previous field?

I have a list of team names in a drop down menu, i would
like it so that when a user selects a team, the next
listbox only contains members of staff in that team.

Hope anyone can help, thanks.

Gavin
 
Use a query for the Row Source of the listbox. In the query, set the
parameter for the Team field to the value of the combo box. In the
AfterUpdate event of the combo box, requery the listbox.

Example?
Me.lstMyListbox.Requery

Referring to the combo box in the query's criteria:
=Forms!frmMyForm!cboMyCombo
 
Back
Top