>>>>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
>
>
>
Maybe another option woulld be
SKIP -1
SCATTER MEMVAR
SKIP
GATHER MEMVAR
Bob
---------------------
Bob Gould
Contemporary Software Systems, Inc.
1665 Briargate Blvd, Suite 101
Colorado Springs, CO 80920
719 574 0300
Bob Gould
Contemporary Software Systems, Inc.
1665 Briargate Blvd, Ste 101
Colorado Springs, CO 80920
719 574 0300