I have developed an MS Access 2007 database with forms that works fine in access, but when I upsize the back end to SQL Server, I completely lose functionality on a sub-form. Has anyone else run in to this problem? Is there a work around?
In my case, after making all of the suggested changes, it turns out that the problematic sub-form was corrupt. I rebuilt the project from scratch in Access 2007 and everything worked fine.