It could be as others have said that moving off the current record
updates the cursor.
I have confirmed that if I use the down arrow to exit the textbox and move to the next *row* in the grid, the calculations in AfterRowColChange() work perfectly, so that shows that the value from the textbox is applied to the cursor beforehand when changing rows. But, when moving horizontally from one column to another, I have to move *2* columns before the calculations based on the underlying cursor work properly.
*Matt Slay*, President Jordan Machine Co. 355 Clow Lane PO Box 170339 Birmingham, AL 35217 Ph: 205-849-5050 Fx: 205-849-5075 mattslay@jordanmachine.com mailto:mattslay@jordanmachine.com http://www.JordanMachine.com
On 09/25/17 10:48 AM, Peter Cushing wrote:
On 25/09/2017 16:04, Matt Slay wrote:
/>> //What is the controlsource for the textbox set to? /
controlsource of the column is: "csrPartTasks.Setup"
textbox inherits same control source.
I have a screen where the user can enter values in a grid and I call a function thisform.sumrows called from grid.AfterRowColChange(). This just saves the record number and sums up the values and displays the result in a textbox below the grid. Never had a problem with a value missing. It could be as others have said that moving off the current record updates the cursor.
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
[excessive quoting removed by server]