Forms

Hi Dusko,
Thank you for the post, in answer to your question, yes you can create a drop down search list on the form.
To accomplish this you could perhaps 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 th 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 lable for the combo box.
Click Finish and go to Form view and test your combo box.
I hope that helps, best regards Pete