A little after debugging, will jump to. TextMatrix (iRow, 2)=txtComm (2). The Text 'unit price in the statement, update form (iRow, 2) represents the first iRow row, column 2, there is a corresponding Text boxes in the table, on the left side of the database established three pieces of information, I understand to row, column begin from zero, so (iRow, 2) will display for the second column, is right?

CodePudding user response:

Row, column subscripts started from zero, is yes, then take a look at, iRow value is beyond the total number of Rows of the grid, iRow values should be less than grid1 Rows

CodePudding user response:

Error message is not very clear, the subscript crossing the line
Do you know this time iRow equals a few?

CodePudding user response:

IRow at this time of what value is, the break point to look at, or before the wrong statements add

The Debug. Print iRow

To observe its value,