Subform Will Not Display 1

[CharlieT302]

Hi Folks,

I have a Main/Subform that works great on the network. The form is located in a Frontend database. The data sources are located in two other databases on the server. Recently, we copied all three databases to a local machine for testing purposes.

The links in the Frontend were updated to reflect the new locations. Everything in the local copy works fine except for the Main/Subform. The subform displays blank, not even the names of the field show up. If I remove the Master / Child links, it displays. This makes no sense as both the main and subform are looking correctly at the proper data sources in their new locations. In fact, each will display its data correctly; but will not display when combined.

Ever see this? We have gone through the links over and over and cannot see anything wrong.

Thanks

 

[hneal98]

try deleting the subform from the main form and adding it again. Sometimes it will become corrupted and needs to be re done.

 

[CharlieT302]

Actually, I thought of that. I even tried creating a brand new Main/Subform based on the same data sources. The subform will still not display. It's a really strange thing. I have not had this happen before.

Any other ideas?

 

[hneal98]

The only other thing I can think of would be some setting either with Access it self or with the new location.

Sorry I could not be more help than that.

 

[CharlieT302]

Thats all right. I found the problem. In case this ever comes up for you, we had Dbase "A" linking to Dbase "B" which in turn linked to Dbase "C"

When we created the "local" copies of all three, we used a Make Table query to pull the linked data from Dbase "C" into Dbase "B" (we were trying to consolidate data). However, doing so removed the primary keys from the necessary fields. Access doesn't like to draw links to a subform if there is not a clear primary field on the main form.

Fixed it by importing the linked tables into a new "third" database. Importing retained the primary key values and all was fine.

Thanks for the help nonetheless.

 

[hneal98]

That is good to note. Thanks.