I know there are many different ways to autopopulate fields on a form. What I am trying to do is have one form that captures part # and 10 individual dimensions to be checked. The second form I have, I want to be able to select the part # in a dropdown (that shows me the part # of all records that have been entered on the first form), and it will populate the 10 fields for dimensions checked. I have two tables set up. One is called Part Information and contains the information for form "Part Information". The second table is the "Inspection Table. They are joined by part # as the primary key. On the inspection table I have part # and date received as the primary key. Do I need to have a query do this? Picture attached may help explain. Thank you in advance for any help.
