>I have a form with a grid on it. The record source property is not set. I have 5 command buttons on the form which correspond to 5 data files. When a button is selected, the file is opened. I want at the same time to refresh the grid with the new data files data. Currently when I select the Data file, I am setting the Record Source property of the grid to the data file and refreshing the grid. This is not working. Can anyone help?

Did you set Grid.Recordsourcetype=1 ?