verify that checkbox is not checked

[hawg1]

Hi,

I'm trying to determine if a check box is checked when I view a record. What is the best way of doing this? I have tried IsNull, but that doesn't seem to work.

My goal is to check the checkbox; if unchecked, remind the user to check the box and then resave the record. The underling table has the checkbox colum formated to Yes/No display.

Thanks

 

[ajetrumpet]

I'm trying to determine if a check box is checked when I view a record. What is the best way of doing this?

Checked ----> = -1

Unchecked ----> = 0

 

[missinglinq]

Private Sub Form_Current()
  If Not Me.YourCheckBoxName Then MsgBox "Check the box, Bozo!"
End Sub

 

[boblarson]

Then MsgBox "Check the box, Bozo!"

Hey ML:

Are we having a "bad hair day?"

 

[missinglinq]

Moi? LOL!

No, but I continue to have a problem on this site! For the last few days when I post a response the %^& thing never shows that it's actually been posted; the hourglass just stays there forever! I've actually timed it at 10 minutes plus a couple of times! If I just go to another site and come back later, the post is always there, but of course it makes working my way thru the forum rather slow!

Linq

 

[boblarson]

Moi? LOL!

No, but I continue to have a problem on this site! For the last few days when I post a response the %^& thing never shows that it's actually been posted; the hourglass just stays there forever! I've actually timed it at 10 minutes plus a couple of times! If I just go to another site and come back later, the post is always there, but of course it makes working my way thru the forum rather slow!

Linq

I've had that happen several times myself and I think it has to do with either Internet traffic at the time, or if the server is doing something like backups. I don't have access to the servers or anything so I can't be sure. Sorry I can't be more help on that one.

 

[missinglinq]

Glad it's not just me!

 

[hawg1]

Private Sub Form_Current()
  If Not Me.YourCheckBoxName Then MsgBox "Check the box, Bozo!"
End Sub

ML,

Thanks for the code. It was exactly what I needed. It helped a lot

Hawg1

 

[ajetrumpet]

No, but I continue to have a problem on this site! For the last few days when I post a response the %^& thing never shows that it's actually been posted; the hourglass just stays there forever!

The refresh button is your friend...