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

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

    Hi,
    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

    Thanks
    Mo

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    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
  •