Dear all, I have a problem with MSFlexGrid.
I have few field and one MSFlexGrid
So i want if i doubleclick any row then the datas of that row distribute to those field
I already wrote the command
Private Sub MFG_Item_dbclic k()
with mfg_item
.Row=.rowsel
txt_Name.text=m fg_Item.textmat rix(row, 1)
txt_Id.text=mfg _Item.textmatri x(row, 2)
txt_quantity.te xt=mfg_Item.tex tmatrix(row, 3)
end with
End sub
but the problem is there is an error message that subscript out of range
then it highlight txt_quantity.te xt=mfg_Item.tex tmatrix(row, 3)
design mode i declare 2 fix column and run mode as per field
so how can i skip this message
I have few field and one MSFlexGrid
So i want if i doubleclick any row then the datas of that row distribute to those field
I already wrote the command
Private Sub MFG_Item_dbclic k()
with mfg_item
.Row=.rowsel
txt_Name.text=m fg_Item.textmat rix(row, 1)
txt_Id.text=mfg _Item.textmatri x(row, 2)
txt_quantity.te xt=mfg_Item.tex tmatrix(row, 3)
end with
End sub
but the problem is there is an error message that subscript out of range
then it highlight txt_quantity.te xt=mfg_Item.tex tmatrix(row, 3)
design mode i declare 2 fix column and run mode as per field
so how can i skip this message
Comment