Results 1 to 3 of 3

Thread: data sheet

  1. #1
    Join Date
    May 2009
    Posts
    72

    Unanswered: data sheet

    hi
    I have a sub form in datasheet view
    I have a calculated field called WEIGHT
    the calculation is done with vba

    the issue is
    if the first row shows a value of 100
    then the second row also shows 100 which is to be 50

    if I click on the second row then
    both the first and the second row shows 50

    same when I click the first row, both the rows shows 100

    the calculation part is ok

    the individual field is not retaining the value independently

    I have attached the picture

    any help will help me take a break for a cup of coffee
    thanks
    Attached Thumbnails Attached Thumbnails row1.PNG   row2.PNG  

  2. #2
    Join Date
    May 2009
    Posts
    72
    GOT IT
    the field was unbound
    created a field in the table

    now works like jaaz

    thanks again

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    As a rule, Calculated Values should not be stored in a Table, they should simply be re-calculated, as needed, in other Forms or Reports. They way to have the value Record-appropriate is to do the calculation in the Control Source of the Textbox. The syntax for that would be similar to this:

    =[Control1] * [Control2]

    Note that the Square Brackets are required when using the Control Names in the Control Source, like this.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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