Subform datasource bug :eek:

[pondlife]

I have a strange bug in Acc2000. For any main form with a subform, when I am designing the subform within the main form and I alter and save the datasource of the subform, the datasource of the main form mysteriously changes to the same datasource. Drives me nutz. Has anyone else seen this. What's the cure?

 

[GolferGuy]

Are you, per chance, using the same query for both the subform and the main form? If so, changing the query for the subform would of course change that query for when the main form uses it.

 

[rolaaus]

Also, you might want to post the code you are using to modify the subforms recordsource, instead of assuming the problem is with Access.

In my many years of programming, I have learned that computers usually do exactly what you tell them, and there in lies the problem ;-)

 

[pondlife]

GolferGuy: no.
rolaaus: occurs in design view, not code.

 

[GolferGuy]

Do you have SQL or a query name as the Object Source for the form and subform? Or does it not matter?

 

[rolaaus]

I built a quick form/subform system out of one of my tables - and at first glance, I must have mixed up the 2 sources, because I had one based on the actual table (the sub-form) and the other I based on a grouped query that basically gave me a list of account numbers, so the sub-form would only show me "transactions" for the single account number listed in the main form. the first time I saw it, I thought the sub-form was giving me the main forms recordsource, and it threw me for a second or two, but while I was writing up my original post (I had to erase and start over) I realized that I mixed the 2 recordsources up, and everything IS in fact working as it should. I was able to change the sub-form and no affect on the main form, then I changed the main form and no affect to the sub-form.

I guess the first thing to try mentioning is doing a repair/compact, and if that doesn't work, this might sound like a waste of effort, but if R/C doesn't work, then try creating a new blank database and importing all objects from the original file. If these don't work, then maybe posting the db file here (if allowed on your end) might help us troubleshoot it, or see if the same file you are working on acts the same way on others' machines.