Look Up Wizard isn't WORKING!!!

  • Thread starter Thread starter Mercy
  • Start date Start date
M

Mercy

I have a Table called OrderForm
I have two fields: Vendor & Product

1) I want Vendor to be a drop down list of Vendors
2) I want Product to be a drop down list of Products
cooresponding to the chosen Vendor.

I was able to do the drop down list of Vendors easily.
But the 2nd task is giving me problems.

I have a QRY, ProductList, which returns a list of Vendors
with their cooresponding Products.
ie:
Vendor Product
Jen Hat
Jen Pants
Vicky Silk
Vince Cotton

The Entire Validation text / Data source for
OrderForm.Product is:
SELECT [ProductList].[Product] FROM ProductList WHERE
[ProductList].[Name]= Vendor;

This only works for the first table entry.
If I chose Jen for the first entry ... the Product drop
don menu shows: Hat, Pants
But in the 2nd entry, even if I choose "Vicky" the product
drop down menu STILL shows: Hat, Pants

Any ideas on how to get around this problem?


Thanks ahead of time!
Mercy
 
Back
Top