In Access 2002 and 03, when you changed a name in a table, the change
automatically propogated to all queries, forms and reports. That
doesn't seem to happen in 2007. Am I missing something or did 2007
really lose this capability? Will the capability return in Access
2010?

Click on the Office button (large circle in the upper left-hand corner),
then select Access Options from the bottom of the form that appears. Click
on the Current Database tab, and scroll down until you see the Name
AutoCorrect Options section almost at the bottom. Ensure that Perform name
AutoCorrect is checked.

Note, though, that most of us recommend not using the so-called
"AutoCorrupt" feature (jsut as we did for Access 2002 and 2003)! See what
Allen Browne has at http://www.allenbrowne.com/bug-03.html for some of the
reasons why.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

"Tomahawk Lady" <nancycmarshall (AT) verizon (DOT) net> wrote

"Douglas J. Steele" <NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote in
news:i2mq69$15v$1 (AT) news (DOT) eternal-september.org:

I actually use it strategically -- I have it off by default, but
when I know I need to do a renaming that has ramifications through
multiple objects, and it's the type of thing that Name AutoCorrect
can actually propagate, I turn it on, let it build the dependencies
table, make the change, let it propagate the change, then turn if
off again.

I've found this works just fine.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/