Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    updating (Access 2000)

    I want to update a field called office in a tabular form called frmUpdate with a function called cash(grossprice, size, code, ddu).
    The names in the brackets are controls on the form.My function works fine if i place it in the OnCurrnet event of the
    form and then it displays the calculated figure.
    I want however to update the entire field in the table through the following command

    Me![office] = cash(grossprice, size, code, ddu)

    However i receive the message " you cant assign a value to this object"

    The record source of my form is the table Products with the following fields
    SELECT products.Productid, products.code, products.categoryid, products.size, products.ddu, products.grossprice,
    FROM products;

    The table products is with a productid as unique number and i have 100 products.
    How can i make my code calclulate with my function cash(grossprice, size, code, ddu)just with one click?
    May be i must loop through all the products in the form and updtate the field office for each product separately
    Can somebody help me ?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: updating (Access 2000)

    The first question most everyone here will ask is: Why are you storing the calculation in the first place? It is generally not a good idea to store calculated fields, since you can never totally rely on the stored total, since any of the components might have been changed without updating the total.

    As to why you are getting that error message. Is there a control on your form by the name of [Office]? If so, what is its controlsource? And can you update the other fields on the form?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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