PDA

View Full Version : Populating a combobox from another comboboxes result


robbiettussin
Mar 11, 2009, 02:10 PM
I have two tables one for example with a list of gaming platforms, and the other table has games but has a look up table for the first table to relate the games to the gaming platforms.

My problem is I need to create two combo boxes, the first so that the user can select the gaming platform from and the second combo box so the user can select the game but only games that are for the platform in the first combobox.

Hopefully this makes sense.

Any help would be greatly appreciated.

Thanks in advance.

ScottGem
Mar 11, 2009, 04:18 PM
This is a standard procedure called cascading or synchronized combos. The following article explains how to do it:

ACC2000: How to Create Synchronized Combo Boxes (http://support.microsoft.com/kb/209576)

robbiettussin
Mar 18, 2009, 02:58 AM
Thank you very much for your response, but I have solved it now, I found a demo database that had three combo boxes that all updated from the results of the others.

Thanks again.

ScottGem
Mar 18, 2009, 05:54 AM
And I'll bet that demo used the techniques described in that article.