Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006

    Unanswered: calculated fields on forms

    hey guys i have a form with several fields on it:
    [shiphandle] as double w/currency
    [subtotal] as double w/ currency
    [tax] as percent
    [markup] as percent

    i have this as the definition on my text field


    so it should do this
    add subtotal and ship handle

    then multiply by 1+whatever the tax percent is (the tax is auto converted to a decimal by MSaccess

    then multiply by the markup percent (same thing as tax)

    however this is not the case i get #name and that it cannot find the field name subtotal which is 100% there!

    any help is appreciated

  2. #2
    Join Date
    Dec 2004
    I recreated your set up and seems to work just fine.

    Are these values being pulled from a table ?

    Would you be able to export this form, with any relevant tables into a DB and attach it, so that we may take a closer look at it ?

    I know it's the obvious ... but take a close look at your spelling.


  3. #3
    Join Date
    Jul 2006
    i got it figured out thank you though:

    i had made a custom control bar with stuff like DEL and SAVE and QUIT and copied the VBA from another form with same control bar i also unknowingly copied the "option compare database" line which seems to mess up everything if that line is duplicated...

Posting Permissions

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