By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,659 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,659 IT Pros & Developers. It's quick & easy.

Can't build a link between unbound forms

P: n/a
I am using Access 97 and have had a problem joining a main form and a
subform.

I have a main form and a subform. The data source on the main form is a
SELECT statement referring to three tables. The subform's data source is
a table.

When I try to link the Child and Master fields, I get the message "Can't
build a link between unbound forms." I have tried typing in the common
fields and it still does not work.

I created a relationship between one of the tables that is in the data
source in the main form and the table behind the subform.

What is really odd is that I have another subform on this same main form
and I linked them with the same fields with no problem.

Also, I had this problem on another main form/sub form.

Any ideas on why I am having this problem. Thank you for any help.

Deborah

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Thu, 16 Oct 2003 00:44:00 GMT, "Deborah V. Gardner"
<dg******@twcny.rr.com> wrote:

That seems to indicate one of the two forms is not bound, meaning it
does not have its RecordSource property set. If you are setting it at
design time, perhaps you are unsetting it at runtime? Or perhaps you
are setting the SourceObject at runtime. I think you have to be
careful with that.
Do the form and the subform show data when run by themselves?

Compare your solution to the Orders form of the Northwind sample app.
It has a subform, and it works well.

-Tom.
I am using Access 97 and have had a problem joining a main form and a
subform.

I have a main form and a subform. The data source on the main form is a
SELECT statement referring to three tables. The subform's data source is
a table.

When I try to link the Child and Master fields, I get the message "Can't
build a link between unbound forms." I have tried typing in the common
fields and it still does not work.

I created a relationship between one of the tables that is in the data
source in the main form and the table behind the subform.

What is really odd is that I have another subform on this same main form
and I linked them with the same fields with no problem.

Also, I had this problem on another main form/sub form.

Any ideas on why I am having this problem. Thank you for any help.

Deborah


Nov 12 '05 #2

P: n/a
I did double check and both forms are definitely bound. Since I already had
another subform working correctly on this main form, I figured it had to be
the subform.

I put the Master field on the main form and set the child and master fields
by typing in the field names. This time it worked and the forms seem to be
working correctly.

Thank you for your suggestions.

Deborah

Tom van Stiphout wrote:
On Thu, 16 Oct 2003 00:44:00 GMT, "Deborah V. Gardner"
<dg******@twcny.rr.com> wrote:

That seems to indicate one of the two forms is not bound, meaning it
does not have its RecordSource property set. If you are setting it at
design time, perhaps you are unsetting it at runtime? Or perhaps you
are setting the SourceObject at runtime. I think you have to be
careful with that.
Do the form and the subform show data when run by themselves?

Compare your solution to the Orders form of the Northwind sample app.
It has a subform, and it works well.

-Tom.
I am using Access 97 and have had a problem joining a main form and a
subform.

I have a main form and a subform. The data source on the main form is a
SELECT statement referring to three tables. The subform's data source is
a table.

When I try to link the Child and Master fields, I get the message "Can't
build a link between unbound forms." I have tried typing in the common
fields and it still does not work.

I created a relationship between one of the tables that is in the data
source in the main form and the table behind the subform.

What is really odd is that I have another subform on this same main form
and I linked them with the same fields with no problem.

Also, I had this problem on another main form/sub form.

Any ideas on why I am having this problem. Thank you for any help.

Deborah


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.