How do I have lookup values be dependent on values from another...

[CPhilpot]

In a vendor table I have a field [Vendor_Name] with a lookup values from a
lookup table for the vendor name. I also have a field [Vendor_Category]. In
Vendor Category, there are subcategories that need lookup values dependent on
the Vendor Name. For example, when selecting Vendor Name ABC Company, that
selection will trigger the Vendor Category field to provide the values that
would only pertain to ABC Company in a dropdown menu. How do I program the
two fields to be dependent on these values?

 

[Rick B]

Do a search for cascading combo boxes. This is asked and answered in the
newsgroups at least once a week. Forms, or FormsCoding might be a better
place to look.

Rick B