>>Hi All,
>>
>>Sorry if I appear a little stressed but I can't figure what I'm doing wrong and I'm sure it's something really dumb.
>>
>>I have a form with a tab frame on it. On one of the tabs I've got a grid which has been initially set to an empty file. I've set various 4 column titles and everything seems fine. I have a button on the same tab which when clicked creates a workfile with the same structure as the table in the grid, when the build is complete I want the grid to display the contents of the workfile. I've tried several ways but to no avail the grid doesn't display the contents of the workfile.
>>
>>When the workfile's built I change the record source property to the name of the workfile and the column control source properties the various fields within the workfile. The recordsourcetype property is set to alias but I did try to set it to table as well, I refreshed the form, set focus on the grid.... nothing worked.
>>
>>Do I have to include the workfiles in the databases or add under the project in freetables before a grid will pickup on the file and it's detail ?
>>
>>Thanks in advance !
>>
>>Don
>
>From what place of your form you fire actual 'grid refreshing' code? The best way is to fire it from the same page.activate event. Also, it's helpful sometimes to reset Grid.ColumnCount property right after you reset Grid.Recordsource. Also, if you make some 'severe' manipulations with initial recordsource table, make sure that you unlinked it from grid, by setting Recordsource="".

Hi Ed,

The grid initially is set to a file (empty) included in the dataenvironment for the form and hooked to the grid when I designed the tabbed form. I'll try setting up the grid in the activate event and see if I get further..... doesn't seem consistant at all.... I reset the grid with 5 columns and no recordsource and when I reran the form I picked up another table from the dataenvironment and displayed the contents without any problem but when I try to set it to a free table nothing shows ????

Thanks,

Don