Access

Hi Steve
Thank you for your post, in answer:
To accomplish this you would create a 'search drop down'; which will look for the displayed item and then produce the record for that item.
Follow these steps; 1. In design view on your form, Locate both the Field List and the Toolbox. 2. Ensure both the Select Items and the Wizards button are shown as selected (coloured boarders). 3. Locate the Drop Down Field (Combo Box). 4. Click on the form in an area with sufficient space. 5. From the Combo Box wizard choose the third option "Find a record on my form based on the value I selected in my combo box." 6. Select the table or query which you wish to search, choose from the Available fields, apply a sort if required, adjust the width of the column. 7. Choose the field to store the value, insert a label for the combo box. Click Finish and go to Form view and test your combo box.
I hope that helps, best regards Pete