Make a field a - number based on combo box

[YNWA]

Hi,

I have a combo box called InOut and the user selects either In or Out.

I also have a field called Amount.

What I need is if InOut = Out then the number I enter into amount has a minus sign before it or stores a minus number?

Is this possible?

 

[edtab]

Try this:

In the AfterUpdate of your Amount field :

If Me.InOut = "Out" then
Me.Amount = Me.Amount * -1
End if

 

[YNWA]

Try this:

In the AfterUpdate of your Amount field :

If Me.InOut = "Out" then
Me.Amount = Me.Amount * -1
End if

It works, cheers!

 

[bob fitz]

It may be better to use:
If Me.InOut = "Out" then
Me.Amount = Me.Amount * -1
Else
Me.Amount = Me.Amount * 1
End if