input a row in a msflexgrid

hi everybody
I want to input a code in the first column of a msflexgrid and the details are displayed inthe rest of the row.
Can anybody help me plz?
here is the code
dim index as integer
index = 1
With grid1
.AddItem (.TextMatrix(index, 1))
strsql = "select * from itemmaster where itemid = '" & .TextMatrix(index, 1) & "' "
index = index + 1
Thanks
prema

create a new db of the data that you want, and tie it to the msflexgrid so that it opens up automatically. make it a bound control.

no ,
in fact i want the user to type in any data, i dnt want the grid to open up with all the data

you just keep track of the row/column that you want, and just assign variables to the textmatrix(row,col). This will fill the grid automatically.
I use a floating textbox that hovers over the cell that I want to change, and then assign it to the cell. You may want to use an inputbox, so you could prompt the user as to what needs to be input.