Referencing a grid cell

[mm0000]

How do i reference a grid cell. If i pass the following to e memory variable it always passes the value of the first row of the column in the grid.

mvar = thisform.grid1.txtbox1.xxx.value

thanks in advance

 

[GriffMG]

mvar = thisform.grid1.column1.text1.value


Regards

Griff
Keep [Smile]ing

 

[mm0000]

That is what I have done - but the value mvar displays is always the first record in the column and does not change when I move the cursor doen the grid.

 

[mm0000]

I have to clarify that it mvar displays correct values of the current column but not values of other columns in the same row. For other coulmns it displays the first record in the column.
eg: 3 columns col1 col2 col3
cusrsor in col3
mvar=thisform.grid1.column3.text1.value
mvar1=thisform.grid1.column2.text1.value
mvar2=thisform.grid1.column1.text1.value

mvar is correctly displayed for col3 but not for column 1 and 2

 

[GriffMG]

have you tried referencing the underlying table/query instead?

mvar = tblMyTable.Myfield
mvar1 = tblMyTable.Myfield1
mvar2 = tblMyTable.Myfield2
Regards

Griff
Keep [Smile]ing

 

[agron]

Try this:

mvar=thisform.grid1.column3.text1.value
thisform.grid1.column2.text1.setfocus
mvar1=thisform.grid1.column2.text1.value
thisform.grid1.column1.text1.setfocus
mvar2=thisform.grid1.column1.text1.value

Let me know if this helped !

Regards

Agron

 

[danceman]

Are you using the default of textbox for the currentcontrol property of the columun? if you assign another control to the columun, like using a checkbox for boolean. if you have checkbox as currentcontrol then use control name, like combo1.value Attitude is Everything

 

[baltman]

You may need to say for example, "go 4", if you want the value from row 4. There may be some other event that is taking the focus off of your "current" row and putting it back at the top of the cursor.

Brian