>I would like to set up a function key so that when you press it the textbox that currently has the focus on a form will grab the value from the preceeding record in the table. Is this possible and if so how? Thanks for the help and happy new year!!!

You can just go to Textbox.Keypress event to intercept appropriate key and fire some code to set Value property to previous record value.