Results 1 to 3 of 3
  1. #1
    jenncivello is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    36

    Form from a Query

    I have a form that is based on a query with a calculated field, if i enter all the information into the form right away it will calculate the total, but if i have to go back and enter the numbers in the form at a later time it will not calculate. Can someone please help. Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    I'm not sure what that means, but it could be if you enter a record, and save the record, the form MAY need a refresh for the calc field to catch up.
    in the form_afterupdate event, put txtCalcFld.requery

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by jenncivello View Post

    ...Can someone please help...
    Not without more information! Where, exactly, is the calculation being done; and what code is being used?

    Linq ;0)>

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 06-03-2014, 05:15 AM
  2. Replies: 7
    Last Post: 06-10-2013, 12:40 PM
  3. Replies: 2
    Last Post: 01-30-2013, 07:34 PM
  4. Replies: 3
    Last Post: 01-15-2013, 01:58 PM
  5. Replies: 7
    Last Post: 05-02-2012, 08:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums