Hello all. I have an ADP application that I need to requery all the time to get the most recent info back from SQL Server. However, the only issue I am running into is on the Bookmark so I can keep the place or on requery I lose the bookmark in ADP the scroll bar moves and the user gets confused because they think they have not clicked anything. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
BOOKMARK MOVES RECORD SELECTOR TO TOP
- Thread starter SeanB
- Start date
dim rst as recordset
dim myID 'Value of current ID field
'Before requery remember ID field's value
myID = me.MyFieldID
me.requery
set rst=me.recordsetclone
'Find previouse record
rst.findfirst "MyFieldID=" & myID 'Use ' for text field
'or # for date field such
'rst.findfirst "MyFieldID='" & myID & "'"
if not rst.nomatch then
me.bookmark=rst.bookmark
end if
rst.close
set rst=Nothing
Aivars
dim myID 'Value of current ID field
'Before requery remember ID field's value
myID = me.MyFieldID
me.requery
set rst=me.recordsetclone
'Find previouse record
rst.findfirst "MyFieldID=" & myID 'Use ' for text field
'or # for date field such
'rst.findfirst "MyFieldID='" & myID & "'"
if not rst.nomatch then
me.bookmark=rst.bookmark
end if
rst.close
set rst=Nothing
Aivars
- Status
Similar threads
- Locked
- Question