im trying to make a form so that when somebody clicks on a part number it open s a new form displaying the new information on a seperate form.
but everytime i try and do it, it keeps asking me for the part number.
the new form i built from a query and i entered in the Criteria column of the part number to retrieve the information from the previous form and relay the info onto the new form.
[Forms]![Form Name]![Field Name]
but it doesn't seem to be looking up the information, all's it keeps on doing is prompting me for a part number which is not what im trying to achieve.