Linking Tables in the Combo Box. 1

[thembela]

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 supposed
to open up the table selected.But what it does is ,it keeps on opening the
first table.

I've assigned macros using (OpenTable )action for each table.to link the three 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 on a list.Any alternative way to do this???

 

[Pampers]

maybe link your tables to forms, and make a combo that opens the forms instead


Pampers.

You're never too young to learn

 

[TheAceMan1]

How are ya thembela . . . . .

Forget the macro's. In the AfterUpdate event of the combobox copy/paste the following ([blue]you![/blue] substitute proper names in [purple]purple[/purple]):

[blue]   DoCmd.OpenTable Me![purple][b]ComboboxName[/b][/purple], acViewNormal[/blue]

The code assumes a one column combobox. If there are more, the combobox reference will have to change slghtly.

See Ya! . . . . . .