Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2016, 02:40 AM
macropod's Avatar
macropod macropod is offline Form fields and bookmarks restrictions Windows 7 64bit Form fields and bookmarks restrictions Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Perhaps:


Code:
Private Sub Document_Close()
Dim Rslt As Long, bStatus As Boolean
With ActiveDocument
    bStatus = (.FormFields("mob_ph_check").CheckBox.Value = False And _
      .FormFields("broad_check").CheckBox.Value = False And _
      .FormFields("car_check").CheckBox.Value = False And _
      .FormFields("vsp_check").CheckBox.Value = False)
    Select Case .FormFields("drop").Result
    Case "Internal"
    If bStatus = True Then
        If MsgBox("Are you sure that contract should be without benefits?", vbYesNo) = vbYes Then .Save
    Else
      .Save
    End If
    Case "Permanent"
    If bStatus = True Then
        If MsgBox("Are you sure?", vbYesNo) = vbYes Then .Save
    Else
      .Save
    End If
  End Select
End With
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to keep formatted form fields after mail merge or replace text with formatted form fields jer85 Word VBA 2 04-05-2015 10:00 PM
Form fields and bookmarks restrictions Form updating Bookmarks - writes to the bookmarks multiple times PeterPlys Word VBA 13 01-14-2015 06:41 AM
Form fields and bookmarks restrictions How To Find Bookmarks and/or custom fields Inside Building Blocks, Office 2010 thpanos Word 3 02-17-2013 08:49 AM
Form fields and bookmarks restrictions Form Fields - Create blank form text field with if statement? LAssist2011 Word 5 12-14-2011 03:02 PM
autopopulating REF fields + bookmarks valz Word 10 09-01-2011 08:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft