View Full Version : Viewing and updating records

Richard Diedrick
08-04-2010, 06:27 PM
This seems to me to be what would be a common application but I have been unable to make it happen. Won't go in to my failed attempts just describe what I want to do.
I need to have a form that displays a record be able to edit that record and then move to the next record in the record set saving the changes before advancing to the next record. The ablity to go forwards or backwards in the record set having changes that were made recorded and viewable as you go forward or backwards.

08-05-2010, 12:48 AM
as i see it you would have to look in stages
1 first selection would be for example where id =1
this displays record 1
on the update statement that would be straight forward
then you would have to re display that again in a form with the id value incremented +1