Check Boxes

  • Thread starter Thread starter Majic
  • Start date Start date
M

Majic

Hey Guys,
I created a form that have 2 check boxes, one for Pass and the other
for Fail. I have both boxes unchecked, however I would like the user
to have to select one or the other before they go to next record.

If anyone could help please let me know

Thank you
 
Put this in the "Before update" event in the form properties. Should work

If IsNull(Me!checkbox1) or IsNull(Me!checkbox2) Then
MsgBox "You must fill in a checkbox", vbCritical
Cancel = True
End If
 
Just thought. Why do you have two checkboxes? Why not have one so "true" is
far pass and "false" is for fail (ticked and unticked)

If your checkbox is based on a score, you can use the afterupdate event in
the score field to tick the box automatically

If score>60 then me.checkbox.value = true ??? Something like that :-)

If you make it read only and disable it then you won't have to worry about it.
 
Hey Guys,
I created a form that have 2 check boxes, one for Pass and the other
for Fail. I have both boxes unchecked, however I would like the user
to have to select one or the other before they go to next record.

If anyone could help please let me know

Thank you
Click to expand...

Did you even bother to read the three replies offering much better solutions?

John W. Vinson [MVP]
 
Option group, Yes/No field, Text field (yes/no/unanswered)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Put this in the "Before update" event in the form properties. Should work

If IsNull(Me!checkbox1) or IsNull(Me!checkbox2) Then
MsgBox "You must fill in a checkbox", vbCritical
Cancel = True
End If

--www.ae911truth.org







- Show quoted text -
Click to expand...

I will try this thank you so much and let you know if it works for me.

Thank you
 
Did you even bother to read the three replies offering much better solutions?

John W. Vinson [MVP]
Click to expand...

I read all solutions and I am trying them, so far it did not work for
me. I am trying some more.
Thank you
 
Put this in the "Before update" event in the form properties. Should work

If IsNull(Me!checkbox1) or IsNull(Me!checkbox2) Then
MsgBox "You must fill in a checkbox", vbCritical
Cancel = True
End If

--www.ae911truth.org







- Show quoted text -
Click to expand...

Thank but it did not work.
 
Thank but it did not work.
Click to expand...


"Doctor, I don't feel good, what should I take?"

Please tell us what you did and in what way it didn't work. We cannot fix a
problem that we cannot see.

John W. Vinson [MVP]
 
Back
Top