Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Location
    Unfrozen in the year 3000
    Posts
    10

    Unanswered: Error on calculated field on a form

    Hello,

    I'm building a straightforward form were the inputter would enter the number of items requested and the number of items then used.

    I'm then adding a calculated field on the form to give me the total remaining - IE: Requested - Used = Total Left.

    This works fine if the number used is less than the requested (say 50-45), but when the values are the same (making the total zero), I get this error when I try to move to the next record:

    "One of more values are prohibited by the valadation rule. '[Number_Requested]-[Number_Used]' set for 'Order_History'.
    Enter a value that the expression for the field can accept."

    Order_History is the name of the table.

    Thanks in advance for any help!
    The Safety Dance!

    Dun-dun-dun-dun-dun-dun-dun-derder!!

    "There are two kinds of people: sheep and sharks. Whoever is a sheep is fired!"

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    And what is this validation rule on that column???
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jun 2004
    Location
    Unfrozen in the year 3000
    Posts
    10
    There is none that I can see!
    The Safety Dance!

    Dun-dun-dun-dun-dun-dun-dun-derder!!

    "There are two kinds of people: sheep and sharks. Whoever is a sheep is fired!"

Posting Permissions

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