2000 2003 subform references

Subform references that work in 2000 but not 2003. I have found a few posts
that say this is a 2003 quirk. How do I correct the problem? Has to work in
2000 and 2003. thank-you

Hi.

Subform references that work in 2000 but not 2003. I have found a few posts
that say this is a 2003 quirk. How do I correct the problem?

Sounds like you are referring to the LinkChildFields problem with subforms
in Access 2003. Please read the following post from Allen Browne (Access
MVP) on the subject, his example, and how to avoid the problem:

http://groups.google.com/group/micro...c30f770?hl=en&

And to avoid other problems, make sure that the Name AutoCorrect option is
turned off for all of your databases:

http://allenbrowne.com/bug-03.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.


"eb1mom" wrote:

Subform references that work in 2000 but not 2003. I have found a few posts
that say this is a 2003 quirk. How do I correct the problem? Has to work in
2000 and 2003. thank-you

There's another issue where 2003 seems to be more pedantic about including
the ".Form" bit when referrring to controls in the subform.

If you're not sure what the .Form means, see:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"'69 Camaro" AM wrote in
message ...

Subform references that work in 2000 but not 2003. I have found a few
posts
that say this is a 2003 quirk. How do I correct the problem?

Sounds like you are referring to the LinkChildFields problem with subforms
in Access 2003. Please read the following post from Allen Browne (Access
MVP) on the subject, his example, and how to avoid the problem:

http://groups.google.com/group/micro...c30f770?hl=en&

And to avoid other problems, make sure that the Name AutoCorrect option is
turned off for all of your databases:

http://allenbrowne.com/bug-03.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message
will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember
that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.


"eb1mom" wrote:

Subform references that work in 2000 but not 2003. I have found a few
posts
that say this is a 2003 quirk. How do I correct the problem? Has to work
in
2000 and 2003. thank-you