Check Box Question

[torquay]

Thanks for taking the time to view this question.
I have a field (a currency field) that is $0.00, is it possible to have a check box (unchecked) and when it is checked it will change the $0.00 field to $20.00. The field will always either be $0.00 or $20.00.
Thanks

 

[boblarson]

Yes, in the checkbox's AFTER UPDATE event put:

If Me.YourCheckboxName Then
   Me.YourTextBoxName = 20
Else
   Me.YourTextBoxName = 0
End If

You should also put that on the form's On Current event so as you move from record to record then it will put the right numbers in place.

 

[torquay]

Works perfect. What a fast response. Thanks

 

[missinglinq]

Your fingers moving faster than mine this morning, Bob, but maybe running a little too fast!

You should also put that on the form's On Current event so as you move from record to record then it will put the right numbers in place.

This is not a formatting thing. One has to assume, I think, that the currency field is a bound field, in which case there's no reason to place the code in the OnCurrent event.