oxicottin
Learning by pecking away....
- Local time
- Today, 18:19
- Joined
- Jun 26, 2007
- Messages
- 856
Hello, I have two questions....
1) I need to use the Tag property to clear my form and that's not a problem. The problem is a few text boxes already have a name in it that's used for verifying data. Can I use two tag names for one control? If so how would I enter it? this didn't work.... (Required, ClearMe)
2) I have a few option buttons I need to untick so how would I add that to my code below?
1) I need to use the Tag property to clear my form and that's not a problem. The problem is a few text boxes already have a name in it that's used for verifying data. Can I use two tag names for one control? If so how would I enter it? this didn't work.... (Required, ClearMe)
2) I have a few option buttons I need to untick so how would I add that to my code below?
If Me.optMon Or Me.optTues Or Me.optWed Or Me.optThurs Or Me.optFri Or Me.optPaperLift = True Then
Dim ctl As Control
For Each ctl In Me.Controls
With ctl
Select Case .ControlType
Case acTextBox, acComboBox, acListBox, acCheckBox
If .Tag = "ClearMe" Then
ctl.Value = ""
End If
End Select
End With
Next ctl
End If