Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Hartford, CT

    Unanswered: Need to save at the time of exiting the record

    I am trying ot add an auto calculate action to the record whenever the form is closed? I do have a calculate button on the form but the user has to remember to press it. I want to make sure that changes are saved if the user forget to push the button and tried to close the form. Help is much appreciated


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    put some code in the before update event of the form
    in design mode view code
    however I'd be cautious as to what calculations you are doing. the smart aleck response is to do do the calculations when you need, ie when your retrieve the data. the other reason given for doing this sort of thing is that there is some flaw in the data model ie you are storing derived data, which is a no no in data modelling terms
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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