Finding equal values from two tables

Finding equal values from two tables

Hi,

I have two tables: frmTempLang & frmTempType.   Each table has an identical string field called strInterp.


What I would like to do, is find equal values from both tables, and use it to populate a combo box.

For instance, the values under frmTempLang could be:

frmTempLang
John
Bob
Ted
Alex
Sandra
Jill

and the values under frmTempType would be:

frmTempType
Alex
Bob
Sandra
Fred
Milton
Karrie
Theresa

What I would like to do, is execute a script on a control's event that would populate a combo box with the matching values.  So, in this case, Alex, Sandra, and Bob would populate the list box.

I've tried using for each values to do it, but the variable scope seems to end once the for next loop is executed.

Any help would be appreciated.

Thanks

Leo