Limit items in combo box

[Ivor Williams]

I have a main form with a subform linked using VendorID. On the subform is a
combo box PartNo which gets its data from a query which includes a table
tblParts. I would like to limit the list of parts in the combo box PartNo to
those parts supplied by the vendor chosen in the main form. How can I do
this?

Ivor

 

[Rick Brandt]

I have a main form with a subform linked using VendorID. On the
subform is a combo box PartNo which gets its data from a query which
includes a table tblParts. I would like to limit the list of parts in
the combo box PartNo to those parts supplied by the vendor chosen in
the main form. How can I do this?

Ivor

The RowSource query of the ComboBox needs to include a reference to the VendorID
field on the main form...

SELECT PartNo
FROM tblParts
WHERE VendorID = Forms!MainFormName!VendorID

 

[Al Camp]

Ivor,
Include the Vendor field in your subform combo query, with a
criteria of...

=Forms!frmYourMainFormName!YourVendorFieldName

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions