Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    override query calculation (a2003)

    I have a form based on a query and some of the form controls display the results of calculated fields in the query because the user wants to do a visual check of the results. The user wants the ability to override the calculation and enter their own figure if they desire. That figure would need to saved in place of the calculation in the underlying query because those values will be summed in subsequent query.

    Has anybody had to deal with anything like this? And, if so, what was your strategy?

    E

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: override query calculation (a2003)

    In that case, you should not put the calculations in the query. Instead, create fields in the underlying table, and update the value of those fields in the After Update event of the fields that contribute to the calculated value in a form. The user will still be able to edit the updated value afterwards.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: override query calculation (a2003)

    must of had rocks in my head. thanks

Posting Permissions

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