option group ?

  • Thread starter Thread starter spanky
  • Start date Start date
S

spanky

i have several option groups in a subform used to
calculate totals for quality tracking. my problem is that
when you go into a new record after entering data on the
previous record the option groups do not reset and you
have to reclick to get them to calculate correctly. any
suggestions?
 
It sounds as if the option groups are not bound to fields in the form. If
that is the case, you can set them to their "defaults" in the form's Current
event. This event runs each time you move from one record to another.
 
you're correct, they are bound to a macro that assigns
values in the subform.

pardon me for this next question, but i'm still pretty
new at this, but how would i go about setting the default?
 
I put "default" in quotes because it won't be the same as setting a default
value for a control bound to a field. You would simply set the value of
these controls to what you want them to be to start out (i.e. a default
value).

In the Current event of the form, you would just list each of them and
assign them a value.

Example:
Me.optOption1 = 1
Me.optOption2 = Null
Me.optOption3 = 2
'etc.
 
Back
Top