>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 will probably want to create your own method to retrieve the value of the last record.

You can also create a property which will handle that value so when you move to the next record you can just get the value from that property.