Find certain records based on value selected in list box or combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have been reading post for a while and can't find what I'm looking for.
I know it should be pretty basic, but I want to be able to click on a
person's name from a list box, then have all the records related for that
person to display.

The user will click on a sales rep's name, then it will do a filter to
display just that person's customers.

Any help would be great. Thank you.
 
First, I would suggest you use a combo box rather than a list box. Base the
row source for the combo on the persons' names.
Create a select query that is filtered on the persons' names with the combo
box in the criteria row:
Forms!MyFormName!MyComboBoxName
I assume the data will be presented in a sub form, so all you need to do
then is in the After Update event of the combo box, requery the sub form.
 
Back
Top