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.

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)

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.

And I'll bet that demo used the techniques described in that article.