Updating a main form

  • Thread starter Thread starter Poul Arne Madsen
  • Start date Start date
P

Poul Arne Madsen

I have a maintable Stak and subtables Detail1, Detail2. The detail forms are
linked to Stak as one to many by the stakNr field. I have enforced
referential integrity and cascadeupdating.

The form is bound to Stak and displayes one record at the time, and two
subforms with details. In the subforms I calculate average values in a field
Average.

How do I get the average values in the subform to be reflected in the
mainformfields bound to Stak immediately as I enter values into the subform?
 
Here's an excellent reference to bookmark:
http://www.mvps.org/access/forms/frm0031.htm

In your particular case, the reference in the ControlSource of the TextBox on
the Main form would be:
=SubFormControlName.Form!ControlNameOfAverage

Using the names of your controls of course.

I have a maintable Stak and subtables Detail1, Detail2. The detail forms are
linked to Stak as one to many by the stakNr field. I have enforced
referential integrity and cascadeupdating.

The form is bound to Stak and displayes one record at the time, and two
subforms with details. In the subforms I calculate average values in a field
Average.

How do I get the average values in the subform to be reflected in the
mainformfields bound to Stak immediately as I enter values into the subform?
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Thanks. It helped a lot.
PAM

Here's an excellent reference to bookmark:
http://www.mvps.org/access/forms/frm0031.htm

In your particular case, the reference in the ControlSource of the TextBox
on
the Main form would be:
=SubFormControlName.Form!ControlNameOfAverage

Using the names of your controls of course.



_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
Click to expand...
 
Glad I could help.

Thanks. It helped a lot.
PAM
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Back
Top