table as datasource

[awake2424]

Is it possible to create a vba button in word 2010 that will prompt a user for a name then connect to that table as datasource? If there are two tables (blue and red in an access database (main). When the user clicks the button and select blue it connects to that table and pulls the information. There are 15 records in the Blue table is it possible to have them be displayes in a single row seperated by commas? Thank you.

 

[rzw0wr]

What you ask is possible I think.
The problem would be that you can not use the same form unless the field names were the same. If the field names are the same then your tables are NOT normalized.

Back up and look at your tables.

Dale