>>>>>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.
Edward Pikman
Independent Consultant