compile a field on checkbox selection

[jsabina]

Hi,


I have a field that I would like to display as checkbox:
expenses - incomings

I have another field "Total amount" where I will put a number as currency.

I would like that if I press the checkbox "expenses" on the field "total amount" will be added the "-" sign.

Is that possible?
Do you have any suggestions?

thanks

[pbaldy]

Sure; at its simplest:

Me.TextboxName = Me.TextboxName * -1

You may want to use the Abs() function in case the user already made it negative.

[jsabina]

and I put that code in the afterUpdate event of the group checkbox?

[pbaldy]

Well, in the VBA editor for that event:

http://www.baldyweb.com/FirstVBA.htm