>>>>>>How do you assign a value to a column (field) on a grid?
>>>>>
>>>>>Any grid has recordsource. If you want to change something in grid, go to recordsource and change data over there. New data will appear in grid.column.control
>>>>thank you - how do you address a column in the grid. I want to add
>>>>some columns together.
>>>>example..
>>>>myvar = thisform.grid1.colummn1.value +thisform.grid1.colummn2.value
>>>
>>>Go to Form Designer and set Column3.Controlsource as Table1.Field1+Table1.Field2 (assuming that Table1 is grid recordsource)
>>--- I found the answer..thanks
>>here it is..
>>
>>if thisform.grid1.column4.text1.value >0 .or. ;
>> thisform.grid1.column5.text1.value >0 .or. ;
>> thisform.grid1.column6.text1.value >0
>>
>> m_val =thisform.grid1.column4.text1.value + ;
>> thisform.grid1.column5.text1.value
>> endif
>
>Surely, you can move on your own, but I guess that I should tell you that you're taking wrong way. Normal way is to define Column.Controlsource, e.g.
>Column4.Controlsource="Thisform.Setcolumn4()" where Setcolumn is form method to calculate needed value you want to see in grid.
---
thanks Ed