Form subform linking quesion

[Sydney1]

Hi,

I have a form and a subform that are linked on the primary key of the main form and foreign key in the subform. When I go into the properties of the form/subform and click on either the link child or master fields to change the linking I get a message saying Can't build a link between unbound forms, and don't get the field linker box to open. I can link the 2 manually by putting in the fields, but not with the field linker box.

However, when I do the same to another form and subform, I don't get that message and the field linker box opens.

What is the difference between the first form/subform and the second form/subform that I stated above.

Thanks in advance for your help.

Sydney.

 

[PHV]

Have the form and the subform a RecordSource ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Sydney1]

Hi,

They all have recordsources. All queries.

Thanks,

Sydney

 

[PHV]

And you really get this error ?
Can't build a link between unbound forms

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Sydney1]

You've been so helpful to me in the past, that I'd never lie to you.

Its a frontend Access 97 DB with a SQL Server 2000 backend. When I attached the subform to the main form, the field link box appears, but if I manually try to change it I get the error.


I received an error 7713 "Reserved error" on Friday and lost connection to several subforms and am trying to ascertain if the above problem is connected to this. My research on error 7713 just states a SQL Server connection error.

Thanks again,

Sydney

 

[Sydney1]

Hi,

Any further help with this issue would be greatly appreciated.

Thanks,

Sydney