Checkbox

[Guest]

Hello, i am trying to check a checkbox with the click action of a command
button but i can seem to be able to do this.

i have entered

Me.[checkbox] = Yes

but this unchecks a checked box but does not check a unchecked box, i want
to achieve the opposite. i know i am missing something simple. can someone
help me.

thank you

 

[Guest]

Me.[checkbox] = Not Me.[checkbox]
If it is True it will change to False
If it is False it will change to True

 

[Sandra Daigle]

Try this:

me.checkbox=true

 

[Guest]

Thank you, thats great !

Try this:

me.checkbox=true

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Hello, i am trying to check a checkbox with the click action of a
command button but i can seem to be able to do this.

i have entered

Me.[checkbox] = Yes

but this unchecks a checked box but does not check a unchecked box, i
want to achieve the opposite. i know i am missing something simple.
can someone help me.

thank you

 

[Guest]

Thanks for the response, really appreciate your help, thank you

Me.[checkbox] = Not Me.[checkbox]
If it is True it will change to False
If it is False it will change to True

Hello, i am trying to check a checkbox with the click action of a command
button but i can seem to be able to do this.

i have entered

Me.[checkbox] = Yes

but this unchecks a checked box but does not check a unchecked box, i want
to achieve the opposite. i know i am missing something simple. can someone
help me.

thank you