[Webinar] Learn how to a build a cloud-first strategyRegister Now


Linking subform to TWO fields on parent form

Posted on 2011-05-10
Medium Priority
Last Modified: 2012-05-11
In Access 2007, is it possible to link a subform to a parent form in the following manner?

Parent form has text fields Name1 and Name2.  The subform has a single text field FullName.  I need to link the two so that Name1+Name2 are linked to the subform's FullName field.
Question by:swpa_wnt
LVL 77

Accepted Solution

peter57r earned 500 total points
ID: 35730585

You have to have the same number of fields in the link fields settings.

Sounds like you need to create a single field from both names in the query you are using for your main form recordsource.

Author Comment

ID: 35730848
I apologize -- I didn't get back to delete this question fast enough.  I realized the impossible task shortly after posting, but also realized I simply needed to add a second field to the table underlying the subform.  This will achieve a similar result to your suggestion: matching the number of linked fields between the record sources.


Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question