J
JBark
I have 3 fields named PUREP1, PUCHG1 and ASIPU.
ASIPU needs to be required if either PURREP1 or PUCHG1 have "If
Len(.Result)=0" character indicated in the field.
I am currently using this could for my required field validation but my
other fields are not conditional based on another fields character count. Can
I adapt this to work or do I need a different solution?
Sub PRODUCTrequired()
'
' PRODUCTrequired Macro
' Macro created 6/11/09 by Art Dep
'
With ActiveDocument.FormFields("PRODUCTrequired")
If Len(.Result) = 0 Then
Application.OnTime When:=Now + TimeValue("00:00:01"),
Name:="GoBacktoPRODUCTrequired"
MsgBox "This field is required."
End If
End With
End Sub
Sub GoBacktoPRODUCTrequired()
ActiveDocument.Bookmarks("PRODUCTrequired").Range.Fields(1).Result.Select
End Sub
ASIPU needs to be required if either PURREP1 or PUCHG1 have "If
Len(.Result)=0" character indicated in the field.
I am currently using this could for my required field validation but my
other fields are not conditional based on another fields character count. Can
I adapt this to work or do I need a different solution?
Sub PRODUCTrequired()
'
' PRODUCTrequired Macro
' Macro created 6/11/09 by Art Dep
'
With ActiveDocument.FormFields("PRODUCTrequired")
If Len(.Result) = 0 Then
Application.OnTime When:=Now + TimeValue("00:00:01"),
Name:="GoBacktoPRODUCTrequired"
MsgBox "This field is required."
End If
End With
End Sub
Sub GoBacktoPRODUCTrequired()
ActiveDocument.Bookmarks("PRODUCTrequired").Range.Fields(1).Result.Select
End Sub