changing values of yes/no variable

[jlabre01]

Hi,

I'd like to know if there's a way to change the value of a yes/no field by using a command button? I want to show whether an item is in stock or not and if it's removed i want the stock to reflected that it's not ther.

jlabre01

 

[ASherbuck]

-1 and 0 I believe

OnClick
If Yes/NoBox = 0 Then
Yes/NoBox = -1
Else
Yes/NoBox = 0
End If

This should make a toggle switch.

 

[pbaldy]

Or even

FieldName = Not FieldName

 

[jlabre01]

thnx, that helped a lot

 

[jlabre01]

what if put a check box on the form to represent the field, how would i uncheck it?

jlabre01

 

[pbaldy]

Substitute

Me.CheckboxName

in either method above.