I'm a new user and i have developed a database for sales orders and tracking
the development of products.  I have my data in tables however I would like
to know how to automatically fill info on forms. For example I have a table
called kit status that has a combo box titled part no.  The combo box control
source is a table called truck assembly.  I want two additional combo boxes
to fill in based off of the PART NO combo box.  I want to select PART NO and
automatically fill in DESCRIPTION and STOCK.  Please help me!!!