Thanks Pbaldy, sleep is the most difficult part of it, getting only a couple of hours here and there. and unfortunately lack of sleep, even more so than Vicodin, really cuts down on cognitive reasoning abilities.
anyway I moved it over to the after update event and still keep getting hung up with the same error
Run_Time Error 2427 "You entered an expression that has no value."
Code:
Private Sub TransAmount_AfterUpdate()
If Nz(Me.Option41 = 2) Then <----error highlights this line
Me.TransAmount = -1 * Abs(Me.TransAmount)
End If
End Sub
I tried fixing with Nz and that dosn't seem to be the problem (or at least not yet)
would it be better/easier if I changed the Option group to a comboBox for making the selection?
Thanks for helping me figure this one out