Parent and child problem

[Guest]

I have problem with form that include subform. From subform is dynamicaly
modified RecordsetSource of parent. In some cases it if functional but in
some cases change make fautl. After every twenties changes is parent to child
and child to parent refference vanished and program termitated with error. I
was trying to bypass vanishing pointer to parent and child by refference to
loaded form but all form controls on forms vanished too as refferences.

It drive me crazy. No help on internet. Can anybody help me? I have windows
XP proffesional sp2 and office xp proffesional. I am using czech language
version of both product.

 

[kingston via AccessMonster.com]

I would take a different approach (maybe not the best approach), and make the
subform data based on a query that is based on the main form. Unless you use
the subform by itself simultaneously (which might be your problem in the
first place), this will create a dedicated and much more flexible datasource.
So, you will have something like:

FormMain (criteria1, criteria2...)
FormSub
Query based on criteria1, criteria2...

Then use the On Current event to perform a Requery.
HTH