Can anyone explain me why a sub that formats a section in the detail part is running three times per recorset or per row, i'm confused ? ?
I needeed to do something like
sub format_blahblah
if field_in_db_mapped_on_a_field_inreport.Value = true
other_field_in_report.SetText "ok it's good"
else
other_field_in_report.SetText "it's bad,bad,bad"
endif
end sub
and in database is
field_in_db_mapped_on_a_field_inreport.Value = true
for first record
true
for second record
false
for the third record
in the end, the messages
are
"it's bad,bad,bad"
"it's bad,bad,bad"
"it's bad,bad,bad"
so i tried also on a query with 8 records and it also runed for 3 times.
I tried to use a counter that has disabled exec of sub after
first execution and the first value keeped the value
"ok it's good"
it's very strange and I wonder if I can ever see the sun anymore ...
I needeed to do something like
sub format_blahblah
if field_in_db_mapped_on_a_field_inreport.Value = true
other_field_in_report.SetText "ok it's good"
else
other_field_in_report.SetText "it's bad,bad,bad"
endif
end sub
and in database is
field_in_db_mapped_on_a_field_inreport.Value = true
for first record
true
for second record
false
for the third record
in the end, the messages
are
"it's bad,bad,bad"
"it's bad,bad,bad"
"it's bad,bad,bad"
so i tried also on a query with 8 records and it also runed for 3 times.
I tried to use a counter that has disabled exec of sub after
first execution and the first value keeped the value
"ok it's good"
it's very strange and I wonder if I can ever see the sun anymore ...