Checkbox Calculations

[darreno]

I have a couple of checkboxes and would like it to perform calculations when checked. Is it possible?

 

[Oldsoftboss]

Sure, but we might need a bit more info...

 

[Guus2005]

Yes that is possible. Use the click or afterupdate or lostfocus or .... event
for a detailed anser we need more info.

 

[darreno]

When checked, qty*daysinmonth. I put the code into the box and the calculation is correct, but the checkbox is not functioning. Attached is the db sample. Thanks guys.

 

[darreno]

I finally figure out how to make it work. I placed an AfterUpdate like so:

Private Sub Check1_AfterUpdate()
If Me.Jul08 = True Then
Me.Jul08 = Me.Jul08 + 1 + [FORMS]![1-Trades]![qty] * 31
End If
End Sub

Thanks.

 

[Oldsoftboss]

Glad you were able to work it out.