What's wrong with this?

[MadHacker]

If (Forms![GC1]!Check1.Value) Then DoThis()<br><br>I am trying to use the above to see wether a checkbox is checked. What am I doing wrong? I have the form opened and the code running from an event on that form.<br>

 

[vbaprogammer]

If Form ... Value = ?????? Then DoThis()<br><br>Actually, there may also be a problem in the syntax for the checkbox.<br><br>Try <br><br>If Me!Check1.Value = 1 Then&nbsp;&nbsp;&nbsp;(or Me.Check1.Value)<br>&nbsp;&nbsp;&nbsp;Do This<br>End If<br><br>I would also rename my checkboxes and other controls so they have a meaning, ckHungry, for example.<br><br>Then Me!ckHungry.Value = 1 Then<br><br><br><br>Dan

 

[jimmythegeek]

You can just use this:<br><br>If Me!Check1 Then<br>&nbsp;&nbsp;&nbsp;&nbsp;Do whatever ........<br>End If<br><br><br>The default for a check box is value, so you don't have to specify<br>value = true or false. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development

 

[MadHacker]

<br>&nbsp;Thank you but neithor one of those are working. I am still gettting an error. It says &quot;Microsoft Access Run-Time error '2447':<br><br>There is an invalid use of the . (dot) or ! operator or invalid parentehesis.<br><br>I tried exactly the way it is shown above by jimmythegeek and the way macrodan shows it and I still can't get past this message!

 

[jazzz]

Try Me.checkbox