vendor tables cascading problem

[mikevds]

Vendor tables
Me.Products.RowSource = "SELECT ProductName FROM"
"Products WHERE VendorID= " &
Me.Categories
_ "ORDER BY ProductName" Me.Products = Me.Products.ItemData (0)

I have a database of all the following tables
Candy list table
Candy item Number
UPC Number
Item Number
Product Name
Catagory Number
Subcatagory Number
Vendor Number
Distributor Number
Department Number
Picture

Catagory Table
Catagory Number
Catagory Name

Distributor Table
Distributor Number
Distributor Name

Product Table
Product Name (same field as candy list table)


Subcatagory AutoNumber
Subcatagory Name

Vendor Table
Vendor Auto Number
Vendor Name

I can't get the 1st combo box vendorname to cascade or update with the second one productsname

can anyone please help me or even create a sample database to help me out.
The coding was created from Microsoft website Synchhronize two combo boxes on a form

I have spent many hours this week populating list boxes but am having trouble.

 

[RuralGuy]

Try:

Me.Products.RowSource = "SELECT ProductName FROM " & _
                        "Products WHERE VendorID = " & _
                        Me.Categories & " ORDER BY ProductName"
Me.Products = Me.Products.ItemData(0)

 

[pbaldy]

Re: Microsoft access populating list boxes problems

Your concatenation is off, as is the spacing between lines. Here's a sample db:

http://www.baldyweb.com/CascadingCombo.htm