Linking values to tables in a Combo Box

[benton via AccessMonster.com]

I got a drop-down list on my form that lists table: Health_Production,
Life_Production and Health_Activations.When I select each table it's suppose
to open up the table selected.But what it does is ,it keeps on opening the
first table.

I've used the macros (OpenTable )action.to link the list values to the
appropriate tables.It keeps on opening the first table.I don't know if
there's any action i should add to each macro.It doesn't want to open the
other two tables in a GROUP MACRO SHEET.