i am building an inventory database.

i want to use a form to find parts.

the form has three combo boxes; vendor, parttype and partno.

after selecting the info in the combo boxes i want access to find records that pertain to the info and have the records appear in an embeded sub form.

thanks

So when you select a vendor, you only get a combo box of the parts that they make, and when you select a part, only the part numbers for that part show up? Try this: http://www.access-programmers.co.uk/ubb/Forum4/HTML/004660.html
If that doesn't work for you, do a search in the Forms forum on 'cascad combo box'.

HTH,
David R

thanks David

this is exactly what i am looking for.

Tom