Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CheckBox Question

Status
Not open for further replies.

ecugrad

MIS
Apr 17, 2001
191
US
First Time with Word. I have the below statements:

If ActiveDocument.FormFields.Item("PLOReq").CheckBox.Value = True

If ActiveDocument.FormFields.Item("MLOReq").CheckBox.Value = True

If ActiveDocument.FormFields.Item("CLOReq").CheckBox.Value = True




If the first statement is true, I want the other two checkboxes to be unchecked. What I have is three check boxes and I only want one to be able to be checked when the user sends the form. Two questions: What do I need to add to rthe statements and do I create a module to put this in, if not where do I place the statements

Thanks in advance...

 
Try this.

With ActiveDocument.FormFields
if .Item("PLOReq").CheckBox.Value = True Then
.Item("MLOReq").CheckBox.Value = False
.Item("CLOReq").CheckBox.Value = False
End If
If .Item("MLOReq").CheckBox.Value = True Then
.Item("PLOReq").CheckBox.Value = False
.Item("CLOReq").CheckBox.Value = False
End If
If .Item("CLOReq").CheckBox.Value = True
.Item("PLOReq").CheckBox.Value = False
.Item("MLOReq").CheckBox.Value = False
End If
End With
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top