code works in 2000, won't work in 2007

  • Thread starter Thread starter Angie
  • Start date Start date
A

Angie

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!
 
Back
Top