Hi Clodoardo,
Thanks for your reply, even if I was not the originator of this thread.
I understood the problem, that Kevin needs to have different tables (or views) with different structure. Therefore I would recommend to check Vlad's FAQ, where he explained this situation in details.
Best wishes,
>I would suggest to create manual view if yow have a pre-known number of table.
>Depending of the table selected you make a view with a common name for all the views. The grid needs to have assigned this name to RecordSource permanently.
>
>For example:
>
>DO CASE
> CASE Table1
> CREATE SQL VIEW MyView AS SELECT * FROM Table1
>
> CASE Table2
> CREATE SQL VIEW MyView AS SELECT * FROM Table2
> ....
>
>And so on.
>
>Then your refresh the grid, and this must works without altering the column width.
>
>It is recommended not to change the RecordSource of the grid in runtime, if the grid is already created in the form.
>
>I hope this help you.
>
>Clodo
If it's not broken, fix it until it is.
My Blog