Linking values in the Combo Box to tables

[benton via AccessMonster.com]

I got three tables named Health_Production, Health_Activation and
Life_Production.These three tables are listed in my combo box on the form as
values.What i wanna do is when i select one table, i.e Health_Production.It
must open up the table.How do i do this ???

 

[Steve Schapel]

Benton,

Well, you can use an OpenTable action in a macro, and set the Table Name
argument to the equivalent of...
=[NameOfYourCombobox]

However, I should say that opening a table is something you should be
very cautious about. The general concept is that tables in Access
should be regarded as background storage, and not normally seen in
active database usage. If you need to access the data for
entry/editing/viewing then it is recommended to use a form.