Re calculate automatically

i already changed the code to this one:

private sub subUnCheckOtherRecords()
Dim strActiveControlName as string
Dim c As Control
strActiveControlName = Screen.ActiveControl.Name

For Each c In Me.Controls
If c.Name Like "chk*" And c.Name <> strActiveControlName Then c.Value=False
Next
End Sub
 

Users who are viewing this thread

Back
Top Bottom