Calculation in Grid - with key board control

[sridhar412]

hi,

I am new to VFP. I am trying grid with a sample table containing code, qty, rate and value as fields.

When the qty/rate is changed in the grid, i want to update 'value' field.

I have tried "replace value with qty*rate" in beforerowcolchange/afterrowcolchange methods.

This does not work when i change the 'qty' field and use 'UP' or 'DOWN' arrow (ie. moving to next
record).

How do i control this?

sridhar

 

[danceman]

you could put your code in the lostfocus event of the textbox of the grid holding the quanity and rate. Attitude is Everything

 

[ganeshg]

U can do it using the follg method

1)Set the Control Source property for the Value field to be (Qty*rate)
2)In the lostfocus event of the text box(rate)ay
Replace Value with Qty*rate
This will update the value field in the table and the 1st point will take care of the calculation.

 

[sridhar412]

thanks.

sridhar