>>>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
Edward Pikman
Independent Consultant