Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Thanked 0 Times in 0 Posts

    Updating Calculations in Protected Form (2000 S/R 1)

    I have created a formula in a form. I have a column of numbers with a formula to total the column. The formula updates automatically when my form is unprotected. When I protect it, it does not update. Is there a way to update the total in the protected form without using an update field macro?

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Melbourne, Victoria, Australia
    Thanked 249 Times in 231 Posts

    Re: Updating Calculations in Protected Form (2000 S/R 1)

    Form fields have a property called 'Calculate on Exit' which causes all of your calculation fields to update automatically when you move the selection out of that form field. Unprotect the form and double click one of your form fields and try putting a check box in this property.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts