Access Tab Control Problem

5 pts.
Tags:
Access 2007 forms
Access Forms Database
Microsoft Access 2007
I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code "[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]" and it would open the form I wanted.  I have however changed the form to put my subforms into tabs. Now "[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]" will not work. what am I doing wrong? Do I need to point to the tab control or something? Any help would be appriciated

Software/Hardware used:
Access 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.

Actually, I had the same problem. Thanks to Roger Carlson at http://www.utteraccess.com/forum/reference-text-box-sub-t1768698.html
I finally fixed it!

For some reason access may have renamed your subform when you moved it onto tabs to “Child##” where ## is some random number. Double-check that’s the problem. I’ll bet it is.

You don’t have to name a tab control when referencing a field on a form. It’s still on that form, whether it’s on the tab control or not.

It’s a relatively old question but I hope it at least helps others who are searching for the answers.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Laura3042000
    Hi there, I'm having the same problem with my database and the fix here didn't work for me. I was just wondering if it worked for you and if not what you did to fix it. Thanks!
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following