Forms Coding

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a form that scrolls through records (At most 10
Records) It is a user form that is used to click option
buttins and the code calculates a score based on how many
option buttons are chosen. The score starts out at 100%
and goes down from there as more option buttons a chosen.

My problem is, #1 on the form load I reset all my
intcounts to 0 and the score to 100% when I scroll to the
next record using the record selectors the 100% does not
carry over. #2 If on the first record I calculate a score
of 50% that 50% starts out to be my score on the next
record when I need it to start at 100%. #3 if I go back to
the first record the score should remain at 50% but if I
start clicking more options again the score continues from
the previous record.

1. How can I default the score to 100% for each record?
2. How do I reset the varible to 100% when I select the
next record?
3. How can I retain the original score if I go back to the
first record.

Any help is appreciated.

-Chris
 
You should be using the form's OnCurrent() event, instead
of its OnLoad() event.

The OnLoad() event fires only once when the form is
opened, however the OnCurrent() event fires as you
navigate from record to record.
 
Back
Top