Check Boxes

[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

 

[scubadiver]

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

 

[scubadiver]

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.

 

[John W. Vinson]

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

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

John W. Vinson [MVP]

 

[scubadiver]

What solutions are they, may I ask??

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

John W. Vinson [MVP]

 

[Jeff Boyce]

Option group, Yes/No field, Text field (yes/no/unanswered)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Majic]

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 -

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

Thank you

 

[Majic]

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

John W. Vinson [MVP]

I read all solutions and I am trying them, so far it did not work for
me. I am trying some more.
Thank you

 

[Majic]

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 -

Thank but it did not work.

 

[John W. Vinson]

Thank but it did not work.

"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]