Solved

can't build link between unbound forms

Posted on 2003-11-30
2
1,081 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
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

762 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

15 Experts available now in Live!

Get 1:1 Help Now