Forum home » Delegate support and help forum » Microsoft Access Training and help » Forms
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Forms
Resolved · Low Priority · Version Standard
Reply Mon 3 Mar 2008, 16:51Delegate Dusko said...
Dusko has attended:
Access Introduction course
Forms
How do you create a drop down query in Form view?
For upcoming training course dates see: Pricing & availability
RE: 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
|