>>>>I have a pageframe with 5 pages in a Form. In page 5 the grid with
>>>>control source from a table TEMP2.DBF is there.
>>>>
>>>>In page 2 , I am modyfying the table temp2.dbf ie adding some more columns. Initially I don't have the table temp2.dbf . It is based on another table temp1.dbf
>>>>
>>>>In Form load event I created table temp2.dbf
>>>>
>>>>But when I come to page5, the grid is not showing any values .
>>>>in any of the columns.
>>>>
>>>>Before coming to page5 I am creating table temp2.dbf
>>>>
>>>>Hope you understood,
>>>>It 's bothering me from past 5 hours.
>
>>>
>>>Try puttting a THIS.Refresh() in the Activate() of Page5.
>>>
>>HTH
>
>>Just Tried it but of no use.
>
>i do almost the exact thing you are describing and i have no problem. make sure that your record pointer is at the first record. do a SELECT TEMP2 then a LOCATE (or go top) . in your grid make sure that your RECORDSOURCETYPE = 1 (Alias) and that your RECORDSOURCE = TEMP2 in the grid PEM.
>
>if still problems, try putting in a messagebox (or in the debugger) and see if you have records in your temp2 table. can also try a grid.refresh().
>
>brenda


Thanks to all.
Now my grid is refreshing.
I did as you told. Initially in the design mode, after getting all the col. properly set, made
recordsource = "" and recordsourcetype = 1 (Alias)
and then while run time, in activate() event , wrote
recordsource = 'temp2'
and again in deactivate() event , wrote
recordsource = ""

Now it is perfectly right.

Now my problem is enabling a column (say col 4) depending on value in col. 3
ie row 1 col. 4 is dependent on row 1 col 3 .

Now where should I write that code ?