Access Drop-down boxes

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