>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?
Kevin,
For start, check this FAQ: How to put grid on the form programmatically 02/05/2001 06:22:47 by Vlad G.
You have to assign grid.RecordSource="" before assigning your table.
If it's not broken, fix it until it is.
My Blog