Results 1 to 2 of 2
  1. #1
    GregShah is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Canton, Ohio
    Posts
    60

    Calculation timing in Form/Subform

    I have two small issues that I believe are related. I created a simple form and subform. On the subform, I have a calculated field that multiplies two numbers that are entered on the subform. However, the resulting product does not appear until I switch off the main form. Similarly, I have a total from the subform display on the main form. This number will not appear until I switch back a record and then reopen the form.



    I think this has something to do wit event procedures but do not have the experience to determine how to correct thee issues.

    Is there a simple way to remedy these two issues?

    Thanks,

    Greg

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    ?? Do you do a requery in this set up??
    You should research and become familiar with Form events

    Another link on Events.

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

Similar Threads

  1. Replies: 8
    Last Post: 05-19-2014, 05:05 AM
  2. Timing issue
    By aytee111 in forum Modules
    Replies: 2
    Last Post: 05-13-2014, 03:47 PM
  3. count (*) timing out
    By aat in forum Queries
    Replies: 2
    Last Post: 12-14-2013, 06:04 AM
  4. timing how long users are on each form
    By salej60 in forum Access
    Replies: 3
    Last Post: 06-07-2011, 08:20 AM
  5. Subform vs main form calculation
    By fadone in forum Forms
    Replies: 17
    Last Post: 12-21-2005, 07:27 AM

Tags for this Thread

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