Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2003
    Washington, District Of Columbia, USA
    Thanked 0 Times in 0 Posts

    Calculations in bound fields (2000)

    I have a form which calculates values based on an event procedure. However, the values are only updated if I enter the field with the event procedure for every record. Is it possible to calculate values in a bound field that will update without having to trigger an event procedure. Thanks. <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Calculations in bound fields (2000)

    If the values you calculate are based on the values of field in the record source of the form, try to do the calculations in a query instead. If the calculations are complicated, you can write a user-defined function in a standard module (not the form module), and use this function in the query.

    Post back with more details if you need more help.

Posting Permissions

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