Stuck option button

  • Thread starter Thread starter Max Yaffe
  • Start date Start date
M

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
 
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
 
Is there anything in CalcAcadDiscountRate or CalcAll that is affecting the
option group, the form, or the data?

Barry
 
Back
Top