I have come across a crazy idiosyncrasy while attempting to migrate from Access '03 to '07. I have a form which contains an unlinked subform. The subform has a list of stuff, and I use VBA code to synchronize the parent based on clicks performed on the subform. Essentially, it works like a listbox, but it is more sophisticated and allows for more flexibility.

Well, migration to '07 wreaks havoc on this strategy, as it turns out. Access '07 links the child and the parent, no matter what you do. Crazily enough, the very same MDB files, after having been opened with '07, behaves normally (i.e. unlinked) in '03. This indicates to me that there must be a bug in '07.

Any suggestions as to unlink child from parent form in '07? This one is driving me nuts...