Access Drop-down boxes

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

Resolved · Low Priority · Version 2003

David has attended:
Access Introduction course

by - delegate David [1 post] (2008 May 14 Wed, 16:46) Reply

Pete,
Some idea of where to start with having several drop-down boxes in forms, which can control what options come up in the next drop-down box would be great.
Thanks,

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	2	book now	£495	£495
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	8	book now	£275	£399
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Access Drop-down boxes

by - trainer Richard platinum contributer [779 posts] (2008 May 19 Mon, 15:49) Reply

Hello David,

Hope you enjoyed your Microsoft Access course with BEST STL Training.
Thank you for your question regarding Drop-down boxes .

What you are referring to is a standard technique called cascading or synchronized comboboxes. Its a standard technique that is illustrated in the sample databases.

First you have to base your pull down list on a query, then add the column for the filtering combo to that query and use criteria of:

=Forms![Formname]![comboboxname]

In the Format tab of the comob you can set the column widths so the country column doesn't show in the pull down.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.
Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

· Get More Out of MS Access Courses
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Take an Access Course to Learn About Relational Databases
· Microsoft Access 2007: New Features

Please browse our web site to find out more about
access course london and other Microsoft training courses.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips