From: lowe493 on
Hey i need some serious help now what i need to build is a parts database i
have got some idea how to do this but im stoped with how to create a subform
i have looked at the sample database northwind and i have decided i like how
that works when a new invoice is made you can select the product from a drop
down bar and then all the fields are filled with that info about the product
i want to be able to do this with my database i need to show the id number
the parts name the price of the part and the quantity of the part in stock
and how many have been bought but the problem i face is i can make a single
celled one but i want one that will show me the certain parts i need on the
invoice thanks

Lowe493 :)