>[snipped]
>>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 ?
>
>In Column4, Add another control. Assuming you're working with textboxes, you would then have Text1 and Text2 in Column4. Make the ControlSource of both textboxes the same. Set the Enabled Property of Text1 to .t. and Text2 to .f. Now, set the value of DynamicCurrentControl of Column4 to something like:
>
>iif(Temp2.field_for_column3 = some_value,1,2)
>
>This will Dynamically Show either the Enabled or Disabled Control in Column4 depending on the value in Column3.
>
>HTH

Thnaks again , it worked.