Check box to store different data??

[Muzicmn]

Not sure where to put this so I placed it in the general section, hope thats right.

My situation is I would like to store a different data instead of a yes/no with a check mark

more specifically, when the check box is checked i would like to store the code "0100" in a different field. I assume this would take an if statement...If "checkbox" is yes then "field" = 0100 but for the life of me i cannot come up with the proper coding or a place to put it

i appreciate any help on this issue

thanks alot guys

Ricky

 

[Rich]

Checkboxes already store a value, 0 and -1, you can convert this to something more meaningful via a calculated control on a form/report or via a query so you don't need to store your numbers

 

[Muzicmn]

makes sense but i am not sure how to make that calculated control, would you mind being a little more specific??

i hate asking questions like this, but i guess it will be the only way i learn

thanks again

Ricky

 

[Rich]

In an unbound textbox on your form
=Iif([YourCheckBox],0100,1000)

 

[Muzicmn]

YOU ARE THE MAN ! ! !

thanks alot really appreciate it

and thanks for the quick responses....

Ricky