SubForm LinK to MainForm - Mystery

[יריב החביב]

Hello,

I use a lot subforms with links to a main form and it work fine.

But now i have subform that although i define the links again and again

is not sinchronize with the values in the main form.

What Can be the reasone ???

Thank's

 

[Allen Browne]

Are you programmatically altering the SourceObject of the subform control?
Or the RecordSource of the main or subform? Or altering the query that the
form/subform is based on?

 

[יריב החביב]

Thnk you,

I Am not altering the query that the form/subform is based on.

and not the RecordSource of the main or subform.

I don't exactly understand what do tou mean by "...programmatically
altering the SourceObject of the subform control" (i dont think i do someting
like this)

But when i open the main form i apply filter to value in other form,

and in my attempts to find solution to the problem i try to apply the filter

also to the subform (l delete it later) so maybe i spoil somthing


thank's

 

[Allen Browne]

Okay it doesn't sound like you are reassigning the SourceObject. (You can
actually load a different form into the subform control by assigning its
SourceObject property.)

Setting the form's Filter should not mess up the linking between main and
subform. But if you filter both the main form and the subform, Access can't
handle it and may misbehave. Details in the point #1 of this article:
Incorrect filtering of forms and reports
at:
http://allenbrowne.com/bug-02.html

 

[יריב החביב]

Thank you allen,

It is very educating but not solve the problem.

I have just filtered the main form and the subform is not sinchronize

as i define the links.

 

[John W. Vinson]

Hello,

I use a lot subforms with links to a main form and it work fine.

But now i have subform that although i define the links again and again

is not sinchronize with the values in the main form.

Please post the SQL view of the subform's Recordsource, the filter you're
applying, and the Master and Child Link Fields. It may help to also post the
datatypes of the fields used in the master/child links.

 

[יריב החביב]

I took the subform from backup version, (before the problem occur)

and replace the problematic subform with it and that solve the problem.

i guess i demaged the subform in some way when "played" with the filters.

Thank you

 

[יריב החביב]

thank you

I took the subform from backup version, (before the problem occur)

and replace the problematic subform and it solve the problem.

i guess i demaged the subform in some way when "played" with the filters.

Thank you