Can't build Link between unbound forms.

[Guest]

I just start getting "Can't build link between unbound forms when I went to check the Link Child Fields and Link Master Fields of my subforms.

Checking my older database versions I saved, everything is working fine.

What might be the problem? I still have relationships as before and primary fields for forms.

 

[Raghu Prakash]

Hi Brian,


SYMPTOMS
When you click the Subform Field Linker Build button next to the
LinkChildFields or LinkMasterFields property of a bound subform property
sheet, you may receive the following error message:

Can't build a link between unbound forms.
CAUSE
The linking field for the main form is not bound to a table or query.
RESOLUTION
You must manually create the link between the main form and the subform by
typing the field names that you want to use in the LinkChildFields and
LinkMasterFields property boxes.
MORE INFORMATION
You will be able to use the Subform Field Linker Builder to link the fields
in your main form/subform combination only if the following conditions are
true:
Both the main form and the child object are based on tables or queries, and
a relationship between those objects has been defined with the
Relationships command.
The main form is based on a table with a primary key, and the subform is
based on a table or query that contains a field with the same name and the
same or a compatible data type as the primary key.
Steps to Reproduce Behavior
Open the sample database Northwind.mdb.
Create a new form not based on any table or query in Design view, and save
the form as Form1.
Add a combo box to the form with the name SelectCustomer.
Set the RowSource property of the SelectCustomer combo box to: Select
CustomerID from Customers ORDER BY CustomerID

Close and save Form1.
Use the AutoForm: Columnar Wizard to create a new form based on the Orders
table. Save the form as Form2, and then close it.
Reopen the Form1 form in Design view and position the form so that you can
see the Database window. Drag the Form2 form from the Database window to
the detail section of the Form1 form.
View the properties of the Form2 subform control, click the Data tab, and
position the pointer in the LinkMasterFields property box. Click the Build
(...) button. Note that you receive the error message mentioned in the
"Symptoms" section.
REFERENCES
For more information about creating links between a main form and a
subform, click Microsoft Access Help on the Help menu, type How Microsoft
Access links main forms and subforms in the Office Assistant or the Answer
Wizard, and then click Search to view the topic.


For Further Information : Microsoft Knowledge Base Article - 207755
,Microsoft Knowledge Base Article - 168872

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Guest]

Raghu, Thanks for the info but why did I have the ability before to use the Linker but now I have to do it manually. I did not change any tables or relationships and I have a version of the database that still works.

Its only just recently that this started. Any ideas on what could have changed?

 

[Raghu Prakash]

Hi Brian,

I was looking at this Further...i am not sure why you are not able to do
it before like earlier,,,
I have few information...just wanted to share this with YOu...hope this
solves...

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)

OR

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.

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.