vendor tables

[mikevds]

Me.subform1.Form.RecordSource = "SELECT * FROM Products WHERE VendorID = " & cboVendorID.Column(1)

This would be for the first combo box for my vendors,
on my table vendor autonumber
vendorname

what would be the second combo box for my products?

Product autonumber
name
Vendor number
catagorynumber

I am trying to link the combo box to the subform
But I have product autonumber associated with autonumber when I go through the lookup wizard it does not let me select sqlqueryassociated with
vendornumberwith productsnumber
Why??

 

[ezfriend]

if you are trying to display related records between your vendor and your product table for the example form you provided, all you need to do is to set the Link Child Field and Link Master Field. This should filter your data for you.