SQL Where Statements

  • Thread starter Thread starter Wendy Willams
  • Start date Start date
W

Wendy Willams

Can I limit the records shown in a drop down list box by
another field on the form? Example: I have a customer
drop down, once the customer is chosen, I would like to
have only the contacts linked to that customer show up in
my Contact drop down. Thank you!
 
Yes this can be done. This is a common application of drop down lists. I
am assuming that your lists are based on a query. In the criteria for your
query set it to "=Forms!NameOfForm!NameOf1stList". On the afterupdate event
of the first list, put in code to requery the second list.

NameOf2ndList.Requery

Kelvin Lu
 
Back
Top