Re: Calculating fields within a SubForm for each record

Tech-Archive recommends: Fix windows errors by optimizing your registry

Somehow, I had gotten the impression you were talking about
a continuous form where setting any property in VBA will
affect all the displayed records.

In single form view you can also use the form's Current
event to adjust each record at the time a user navigates
from one record to another.
--
Marsh
MVP [MS Access]


JNLSeb wrote:
Thanks for the input, but I should have been more clear but was not sure how
to describe what I am doing.
This may be better.

I am actually calculating the size of an embedded picture based on the value
of a specific field.
This picture is not stored within any table and is displayed at a given size
only when the data is viewed within the form.


JNLSeb wrote:

When a SubForm is loading currently a calculation is being done for each
record but the values are based only on the first. So, if the subform has
20
records, the value of this "special" field is being populated for all 20
fields but the value is done based only on the first and not each
individual
record.

Where should the code be place to have it calculated for each record on
the subform?


"Marshall Barton" wrote
Either in the report text box's control source expression or
as a calculated field in the (sub)form's record source
query.
.

Relevant Pages

  • Re: Calculating fields within a SubForm for each record
    ... I am actually calculating the size of an embedded picture based on the value ... So, if the subform has ... Either in the report text box's control source expression or ...
    (microsoft.public.access.formscoding)
  • Re: where to put my If Statement to update subform
    ... update all the displayed records as the subform is populated or ... Just remember that the data is NOT stored in the subform - it's stored ... the form to display the changed data. ... John W. Vinson ...
    (microsoft.public.access.formscoding)