I am really quite new to this. I found a bit of code in these forums that
allowed me to get data entered in a form to remain in the text boxes after
you started a new record. This was wonderful, and just what we needed.
Problems arose when someone tried to use this form in Access 2007. The text
box was blank when you started a new record, where as in 2000 it carries the
data over.

Here's an example of the code I used:

Sub TAGR_AfterUpdate()
With Me.TAGR
..DefaultValue = Chr(34) & .Value & Chr(34)
End With
End Sub

Is there something I need to alter to get it to work in both 2000 and 2007?
Any help would be greatly appreciated.

TAGR is the name of the text box in the form, not the database its self. The
form has about 30 data entry points, only about 5 or so that need to have
data carried from one record to the next.

And thank you very much, when my boss gets back I'll have her set the folder
to trusted!

"Linq Adams via AccessMonster.com" wrote:

> Also, what Datatype is TAGR ?
>
> --
> There's ALWAYS more than one way to skin a cat!
>
> Answers/posts based on Access 2000/2003
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200810/1
>
>