Problems multiple sub-forms in design view, properties change by ghost

[dan123]

I use access 2000. Never had this problem with 97

I’ve got my Master Form organised with 4 subforms and all the appropriate fields linked but, and it’s a very frustrating but, when I move from design view to form view, the Source Object for 2 of my subforms changes to be the same as one of the other subforms. This means that the Master form ends up with 3 subforms looking the same as they have the same Source Object. If I go back into design view and change the Source Object back to what it should be, it will work once as it should, but then it repeats the above problem the next time I go to form view. Is there a particular property that I may have incorrectly set on these 2 subforms? It’s driving me mad and threatening to consume my life this week!
One thing I tried was to re-create another Master form and drag the subforms onto it.
The problem repeated itself.
Hope you can help me,

 

[ghubbell]

Hi Dan,
Wopping headache that is. Check each name of your subforms. Not their name when you look at them on their own, but their name when you click on them once while looking through the main form. At that time as well, check your linked fields again. If all else fails, clean off your main form and with the wizard button depressed, drag out your subforms again one by one and follow the wizards steps. Take note of the names and links while you do this and make sure you aren't accidentally crossing something up. Good luck and let me know how you do... Gord
ghubbell@total.net