Unable to remove master -> child subform links in microsoft access 2003

Question

Hi,

I am having an issue removing the master -> child link fields in an access subreport data form. I have tried every avenue to remove them, using the properties window of the subreport as well as the link wizard. I have also deleted the subreport from the database and then gone as far as re-importing the existing objects into a new access instance. As soon as I re-added the subform back in and name it the same name the link fields show back up. Something is apparently corrupt, but I have run out of ideas at this point on how to clear them.

Any Ideas would be appreciated.

Thanks Doug

Answer 1

You have to remove them from the SubReport / SubForm object on the Master page / Master form. If you drop and recreate the child form the linkage is still not broken.

If not, VBA code could actually be setting these properties. You should open up a module and search globally for the value (the one that is set in the link fields property).

Also, if the linkages are set in the table as relationships, every time you add the child form object, access with auto-magically fill up the relationships for you. If you want to remove them, you may have to do that manually.

Answer 2

Ok Thanks Raj - Yes the issue is due to the fact that the sub-report was bound to a table and was in fact "magically" inferring the link fields. In order to remove the links permanently you have to remove any reference to a data-source...table, query, sql etc.

Thanks, Doug