microsoft access courses - Drop-down menus in forms

The UK's most regular instructor-led training courses.
Training information: microsoft access courses · Access course microsoft training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Drop-down menus in forms

Sarah has attended:
Access Introduction course
Access Intermediate course

by - delegate Sarah [4 posts] (2007 Jul 19 Thu, 09:47) Reply

How can I create drop down menus in a form, so that data inputters can choose between various options?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 3 Wed	Southwark	0	FULL
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	7	book now	£190	£224
2003	2008 Nov 5 Wed	Southwark	7	book now	£190	£224
Full Schedule: See all 54 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Drop-down menus in forms

by - trainer Richard platinum contributer [785 posts] (2007 Jul 20 Fri, 10:12) Reply

Hi Sarah,

Now that you have done the Intermediate course, you know how to create a Lookup list in a table using the Wizard.

Forms have similar wizards, in that if you add a Combo Box control to the form, and you have the Wizard's Wand highlighed on the toolbox, you should have a Wizard start once you add the control. This will step you through creating the lookup for your control.

Let me know how it goes, or if you require any further assistance.

Regards

Richard

· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Material covered on a Microsoft Access Course
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Access VBA Training Adds Power to your Databases
· Access VBA Handling Errors and Debugging Code

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips