>What method do you guys use to navigate thru records using the VCR style Navigation buttons when doing a client server application?
>
>I have never used these buttons in my client server development but I have a client now that wants them and he's the boss :).
>
>Thanks.
That's a helluva question for client/server especially since you have to table to skip through. The easy answer is the get the record with the primary key value right before or right after the current record on your form.
If you have some way of determining what "sort order" the user wants to skip through the records by, you could pass that field's current value along with a direction to a stored procedure that returns the PK value of the record before or after that value. Then use that PK value to requery your data. Getting first and last record form a particular sort order would be a little easier.
Mark McCasland
Midlothian, TX USA