Suppressing a msgbox

[alphabetsoup]

I'm being driven crazy and there must be a way to do this, or at least a way to change my form so that what I need to happen actually happens.



My form...this is a check out system. A user will type in the record number and the type of record will appear, as will a check box, a box for student name, and a box for check out date.

If the record is being checked out, the user will click the checkbox. When that checkbox is clicked, I need a message box to popup that says "Please enter student name and check out date". I managed to accomplish this using the expression builder.

NOW...when that checkbox is unselected...how can I get that message to NOT appear? It appears on click, but I only need it to appear if the box is checked.

I can't get any conditions to work, in fact, I'm pretty sure I'm not even writing them correctly. If this isn't possible, does anyone have any other ideas for the design of this and how I need it to work?

[pbaldy]

In VBA code:

If Me.CheckboxName = True Then

[alphabetsoup]

For crying out loud. I've spent 2 hours trying to get that to work. Maybe I had looked at it for too long or something (I started this on Sunday). Thank you for your help, that worked exactly as I wanted it to!

[pbaldy]

LOL! Happy to help, and welcome to the site by the way. Also, you can shorten that to:

If (Me.CheckboxName) Then

which is less intuitive but less typing.