I have many copiues of the same table which.

I want to use a grid to display this data, but I want to allow
the user to pick which table to view from.

So after I prompt the user to pick a table, I cant seem to get the
grid to display it correctly.

After the table is picked, I set the grid's RowSource to the name
of the table, and the control sources of each column to the fields.

Yet the grid displays the whole table, regardless.

How do I do this?