how create drop down


starstarstarstarstar Excellent

Forum home » Delegate support and help forum » Microsoft Access Training and help » How to create a drop down menu in access

How to create a drop down menu in access

resolvedResolved · Urgent Priority · Version 2007

Wed 23 Apr 2008, 16:16 replyReply Delegate Farhad said...

Farhad has attended:
Access Introduction course

How to create a drop down menu in access

how to create a drop down menu in access? and how to link all the information once a drop down menu is created.

For upcoming training course dates see: Pricing & availability

Tue 6 May 2008, 16:46 replyReply Trainer Pete said...

RE: how to create a drop down menu in access

Hi Farhad,
Thank you for your post, I hope you enjoyed your course. In answer to your question; I am assuming that you mean a Combo Box control on your form; if so;
A combo box comprises a drop down list of items, yusually bound to an underlying field, from which one entry can be selected. The advantages of using a combo box are:
The list will only display existing values in that field
There is less danger of data being misspelt or inaccurate because it is chosen from a list
The combo box takes up less space on a form than a static list.
To create a combo box using a wizard:
1. Ensure that the Control Wizards button in the toolbox is depressed.
2. Click on the Combo Box button in the toolbox
3. Click on the form to add the combo box to it.
4. Follow the steps displayed by the wizard to create the combo box.
To create a combo box manually:
1. Ensure that the Control Wizards button is not depressed.
2. Click on the Combo Box button on the toolbar
3. Add the Combo box to the form.
4. Set the properties of the combo box as required - select the combo box and click on the Properties button, or right click on it and choose Properties
The five most important properties of a combo box are listed below:
Control Source: Defines the name of the field in the underlying table or query that will be updated by the combo box.
Row Source: Defines the table or query that supplies data used to create the list
Row Source Type: Defines the source type for the list. This can be Table/Query, Value List or Field List
Bound Column: Defines which of the columns used in the combo box returns its value to the Control Source.
At this stage, change to Form View and test that the combo box is working, If it will not let you select an item from the list, the most likely reason is that you have got the Row Source and Control Source properties reversed. I hope that has helped you, if so please click the Resolved link, Best Regards Pete Emmerson Microsoft Office Specialist Master Instructor


Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips