Solved

can't build link between unbound forms

Posted on 2003-11-30
2
1,082 Views
Last Modified: 2012-06-27
Hi,

When I tried to link a child field with a master field, an erro message pop up "can't build link between unbound forms". How could I make my form and subform as bound?

Thanks a lot.
0
Comment
Question by:robinyanwang
2 Comments
 
LVL 10

Accepted Solution

by:
jobrienct earned 300 total points
ID: 9848683
when you create your forms using the wizard it asks you what table/query to base the form on. Using this information it sets the forms record source in the forms properties. this binds your form to the table/query you selected.

If both forms are bound in this way then when you add the subform it will suggest the link if it finds like fileds in both record sources.

for example

tblContacts
-------------
ContactID
FName
LName
Phone1
etc.


tblCalls
--------
CallID
ContactID
Notes
...


if you add a form based on tblCalls to the main form based on tblContacts then the subform wizard will pick up the similar fields and creat the link (with your approval)

regards,

John
0
 
LVL 8

Assisted Solution

by:Benjamin_Luk
Benjamin_Luk earned 200 total points
ID: 9848758
Suppose your table name is myTable,
 Please set the data record source : myTable

Step: 1. Open your form in design view
         2. Double Click on the left top tab
         3. In the From Properties
         4. Select Data
         5. In the [Record Source], enter you table name.
         6. Save and close it.



Regards

Ben
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
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…

911 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now