Linking field in form to different form.

[budhead]

I have a form based on the results of a query, including an item number field.

I would like to be able to click on the item number and open a different form that allows me to modify the properties of that item (I have created that form already, which is based on a query, and prompts for an item number when it is opened).

How would I create such an action? Thank you!

 

[daveUK]

Put a cmd button next to the details of the 'Items Not Yet Shipped' and use the wizzard to open a the form with the details on where the ID on the 'Items Not Yet Shipped' form is the same as the ID on the details form.