Pls help requery subform

[Fjordur]

Hi,
I have this form with 2 subforms, both linked to the master form. The
master form is a personal info form.
Subform A lets me add or delete records of a linked table (skills for
the person).
Subform B is a snapshot based on a (rather complex) query that looks the
skills and shows what we call qualifications (you have to have a
specific set of skills to qualify for a specific qualification).

I'm trying to have subform B to recompute and refresh whenever I modify
data in subform A. I tried to set procs for the delete and insert events
of subform A with code like
forms!Person![subform B].requery
forms!Person.refresh
but this doesn't work although a manual refresh in the "records" menu
works.
What's the trick? Can anyone help? Thanks

 

[RuralGuy]

Hi,
I have this form with 2 subforms, both linked to the master form. The
master form is a personal info form.
Subform A lets me add or delete records of a linked table (skills for
the person).
Subform B is a snapshot based on a (rather complex) query that looks the
skills and shows what we call qualifications (you have to have a
specific set of skills to qualify for a specific qualification).

I'm trying to have subform B to recompute and refresh whenever I modify
data in subform A. I tried to set procs for the delete and insert events
of subform A with code like
forms!Person![subform B].requery
forms!Person.refresh
but this doesn't work although a manual refresh in the "records" menu
works.
What's the trick? Can anyone help? Thanks

Try: forms!Person![subform B].FORM.requery
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Fjordur]

I have this form with 2 subforms, both linked to the master form. The
master form is a personal info form.
Subform A lets me add or delete records of a linked table (skills for
the person).
Subform B is a snapshot based on a (rather complex) query that looks the
skills and shows what we call qualifications (you have to have a
specific set of skills to qualify for a specific qualification).
I'm trying to have subform B to recompute and refresh whenever I modify
data in subform A. I tried to set procs for the delete and insert events
of subform A with code like
forms!Person![subform B].requery
forms!Person.refresh
but this doesn't work although a manual refresh in the "records" menu
works.
What's the trick? Can anyone help? Thanks

Try: forms!Person![subform B].FORM.requery

Thanks, but it seems the form IS requeried, as shown by the fact that a
simple refresh, manually, does show updated data. The problem is, my code
above does not display the new data. The "forms!Person.refresh" line has no
apparent effect. How do I do the equivalent of a 'manual' refresh?