Stuck option button

[Max Yaffe]

I have several option groups with True/False buttons. The groups have
BeforeUpdate & AfterUpdate event handlers in VBA attached to them.

The buttons get "stuck", i.e. When I select TRUE, the events fire OK,
the tables are updated, etc. But I can't select the FALSE button. No
events fire when I click on it. Likewise, immediately after I have
selected FALSE, the TRUE button in nonresponsive.

If I move to a different field outside of the group, the stuck button
becomes available. But as soon as I select it, it's opposite button
becomes nonresponsive, again.

Here a sample of the code in the BeforeUpdate & AfterUpdate:

Private Sub fmeAcadDiscountApplies_AfterUpdate()
Me.Refresh
End Sub

Private Sub fmeAcadDiscountApplies_BeforeUpdate(Cancel As Integer)
Me.AcadDiscountRate = CalcAcadDiscountRate(Me.DistDiscountApplies,
Me.AcadDiscountApplies)
Call CalcAll(Me, "Quote")
End Sub

Any ideas what may be causing this?

Thanks,
Max

 

[Guest]

Are these option groups bound to anything? What happens in the calls you're
making?

 

[Max Yaffe]

The control is bound to a field in a query. The Before and
AfterUpdate events are never getting triggered. It's almost as though
the control is disabled and not selectable.
Max

 

[Guest]

Is there anything in CalcAcadDiscountRate or CalcAll that is affecting the
option group, the form, or the data?

Barry