>>>>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.
>>
>>Edward,
>>i get what you mean, but how do I do it?
>
>Take it easy:
>&& KeyPress event
>if nKeyCode=28 && any code you like (see INKEY() in manual)
> select your_table
> skip -1
> this.value=your_table.your_field
> skip
>endif

Won't the record be written to the table when the record pointer is moved?

Craig