code works in 2000, won't work in 2007

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.
 
A

Angie

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top