11 thousand parts database problem

[Guest]

I have a database with over 11 thousand parts and I want to filter so that
when I pick one vendor only the parts associated with that vendor will
display. Is this possible?!

 

[RobFMS]

Create a query:

Select <field1>, <field2>, <field3>, ... <fieldX>
From <table>
Where Vendor = "Acme"

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[PC Datasheet]

Your tables should look like:
TblVendor
VendorID
VendorName
etc

TblPart
PartID
VendorID
PartNum
PartDesc
etc

Create a query named QryVendor based on TblVendor. Make VendorID the first
field in the query and VendorName the second field. Sort ascending on
VendorName.

Create a query named QryFrmPart based on TblPart. Sort ascending on PartNum.
Put the following expression in the criteria of VendorID.
Forms!FrmPart!VendorID

Create a continuous form. Name your form FrmPart. Your form should be a
continuous form so you get a list. Base the form on QryFrmPart. Add an
unbound combobox in the form header. Name the combobox VendorID. Set the
Rowsource property of the combobox to QryVendor. Set the Bound Column to 1,
Column Count to 2 and Column Width to 0;2. Put the following code in the
AfterUpdate event of the combobox:
Me.Requery.