Hi,
I have a grid who's recordsource is a sql statement. Anyways, I have 'move up' and 'move down' buttons on the form. I've got that working. After some troubles I was able to get the grid to refresh. Here's how
with thisform.grdQuestions
.recordsource="select question, rank, tkey, qkey from qtable " + ;
"into cursor questions order by rank" + ;
" where tkey = '" + lcTkey + "'"
.refresh()
.setfocus()
endwith
Here's the problem I don't know how to solve. After the grid is refreshed I would like the record that was moved to be still highlighed, instead of the first record being highlighted. For example,
grid contents before move down
"Hello"
"How Are you"
"I am fine"
grid contents after move down
"How Are You"
"Hello"
"I am fine"
Any ideas? I tried making a index on the cursor and seeking the correct record after the refresh, but that caused problems.
Chris