Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1162
  • Last Modified:

can't build link between unbound forms

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
robinyanwang
Asked:
robinyanwang
2 Solutions
 
jobrienctCommented:
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
 
Benjamin_LukCommented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now