Page 3 of 3 FirstFirst 123
Results 31 to 32 of 32
  1. #31
    sud2017 is offline Competent Performer
    Windows 7 64bit Access 2003
    Join Date
    Jul 2017
    Posts
    148
    You simply ROCK. This worked so smooth. This is exactly what I wanted. This works when the subform is Open as well as close. I have added a Refresh Button in my Main Form to refresh my data in Main Form every time after I update my subform. Thanks a million.



    Quote Originally Posted by davegri View Post
    In the afterupdate event for text21:
    Code:
    tempvars!totalPrice2 = text17 + text23      'calculate it just like text25
    It's hard to understand the process due to textbox control names like text25, text21, etc.
    These should be named something like txtTotalPrice2 and txtMarkupPct. It would make things much less confusing.

  2. #32
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,741
    Glad to help. Keep plugging away - good luck with your project!

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Passing Data From One Form to Another
    By CharlieK in forum Access
    Replies: 19
    Last Post: 10-31-2016, 07:48 PM
  2. Passing Data From One Form to Another Form
    By ETCallHome in forum Forms
    Replies: 6
    Last Post: 03-12-2011, 12:53 PM
  3. Passing Data from on Form to Another..
    By ETCallHome in forum Forms
    Replies: 2
    Last Post: 03-12-2011, 12:26 AM
  4. Form not passing data to query
    By bobfin in forum Queries
    Replies: 13
    Last Post: 08-11-2010, 05:28 AM
  5. Passing data to sequential form fields
    By jeepfamilyva in forum Forms
    Replies: 0
    Last Post: 06-28-2009, 11: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