Hi!
Take a look to the FAQ#8019
>Hi,
>
>finally I did it now! Thanks for your help and reply! I was having some typo in the code LOL
>
>once I set the recordsource to the new table, ALL layout config of the grid is messed up, are there any way to avoid from changing other settings when I set the recordsource?
>
>I know I can code the layout setting every time I update the table, just want to know if there is any smarter way :)
>
>Thanks a lot!
>
>Jimi
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.