How to return to active row in Grid?

[Millard]

How can I return to the same active row in my grid after printing?
The record pointer goes back to row 1 in the grid instead of the current row.

I set a variable for the current row, i.e.,
Thisrow = Recno()
...printing current row
MYGRID.SETFOCUS()
MYGRID.ActivateCell(thisrow,1)

The record pointer goes back to the 1st row of the grid
instead of the current row. What's wrong?

Millard

 

[JimmyK]

Hi, i think this works
Thisrow = Recno()
...printing current row
Go ThisRow
MYGRID.SETFOCUS()
Jimmy Le
nhan_tiags@yahoo.com

 

[danceman]

Thisrow = Recno()
...printing current row
go Thisrow
MYGRID.ActivateCell(thisrow,1)
MYGRID.SETFOCUS()

Attitude is Everything

 

[Millard]

Grid returns to the current row, then pops back to the
first row in the grid. Still can't get the cursor to
remain in current on after return from printing..

Millard

 

[danceman]

what are you printing? the record of the row cursor is on? Attitude is Everything

 

[MCTCO]

Sounds like you may have some code in the activate event of the form that changes the position of the pointer.

 

[Millard]

TO MCTCO

You are correct. I do have code in the activate event which
requery a combo box on the form and calls a method which then retrieves data for the grid based on the first name in the combox. However, after making a selection from the combo box and printing a selected row in the grid, the cursor returns to the 1st row in the grid instead of the current row. Does the activate event fires again after the printing occurs?
If so, then this would obviously be the problem.

Any suggestions on work arounds?

Thanks
Millard

 

[danceman]

I have succesfully used

ActivateCell
then refresh

if this is not working I suggest you use the debugger to trace each line. as you trac check the program display. Attitude is Everything

 

[MCTCO]

the init event fires only once during the life of the form. The activate fires each time the for recieves the focus (like after a print window or messagebox).