Skip to Content
0
Former Member
Feb 07, 2007 at 08:08 PM

Recordset Navigation Help

39 Views

Good Afternoon

Experts:

I have quite the dilemna this afternoon. My application performs a simple select all records from a table to initialize navigation...previous, next, first and last.

However, I now have added a routine to load the last viewed record, by the

logged on User, in the recordset. This now causes the original navigation

to not be in order.

My Question:

Is it possible to perform the select all records and then position a "cursor/index/reference starting point" to a value in that recordset?

Example:

Recordset returns:1,2,3,4,5,6,7,8,9...etc

LastViewed = 5 so base all navigation off of 5...6 next record, 4 is previous record

Thanks,

Ed