Hi --
I have a form with review_id in the ID text box. I have two subforms,
Evaluation and FollowUp both of which have ID as the Link Master Fields
value and Review_Id as Link Child Fields in the Data tab of the property
box. As far as I can see the property specs for the two subforms are
identical. The difference is that the two subforms go against different
tables but both of those tables have a Review_Id field for creating the
link. The Evaluation subform stays perfectly in sync with the value in the
ID text box of the parent. The FollowUP subform sometimes stays in sync but
mostly shows all the records in the Followup table, not just those with a
review_id equal to the ID in the parent form text box. I have tried
Evaluation.Form.requery whenever the ID on the parent changes but it doesn't
help.
Is there some other way to force the synchronization?
Thanks,
Barry