Column, row, cells

[Former Member]

Hi,

I mange to access the system matrix in tha sales order form. (oItem = oOrderForm.Items.Item("38"))

1. But how can i access the system column?

2. How can i get/read the value in the specific cells (like the VB Gatagrid, TableLines.Rows(row).Item(0))

• the value that entered in the system matrix not yet saved.

because i need to record the value to another tables before adding the value/data to sales order.

thanks in advance.

Bruce.

[Former Member · Accepted solution]

Hi Bruce,

First you have to get the matrix - which you did, but as an Item. Then you have to get the desired column and get convert it to the type of control it is (check, edit, combo, etc.) The get the value.

oMatrix = oItem.Specific
oColumn = oMatrix.Columns.Item("ColumnID")
oEdit = oColumn.Cells.Item(iRow).Specific()
sVal = oEdit.Value

Hope t helps,

Adele

[Former Member]

Yahoo!!!

Thanks Adele