You can download a template for Access 2007 that demonstrates how to synchronize two combo boxes. For example,
Office 2010, say you choose a category from one combo box, and you want a second combo box to only display products within that category. The template shows you how to make it happen. On the Getting Started page of Access,
Windows 7 Key, click Sample in the left pane,
Windows 7 Key, and then click How to synchronize combo boxes. Click Download,
Microsoft Office Professional 2010, and Access launches the template. The template contains all the instructions you need to set up combo boxes of your own,
Microsoft Office Professional 2007, whether you want to use VBA code or macros. You can also download the template via Office Online here. <div