>I currently am changing tables in a grid based on a file selected by a user. When I successfully change the tables, I loose the rightclick property in a column header. Any ideas on how to reset the rightclick property or retain the property while changing tables.

There are few ways. One of them, probably better suited to your case, is to use custom textbox in your column with RightClick code added in Class Designer. This way you will use in run-time Column.Add/RemoveObject any time you switch grid.recordsource.