Solved

Can't get total field in form to update

Posted on 2011-09-02
5
300 Views
Last Modified: 2013-11-27
Great Day, I have a form that calculates service items performed by a technician. Each time the user enters a service item and and associated cost or if he/she edits an existing cost, I want txtRepairTotal to update, but this does not happen until I move away from the record and then return. I have Do.Cmd.Requery "txtRepairTotal" in the AfterUpdate event, but it is not giving me the expected results. There is no change to txtRepairTotal.

Thanks in advance for your assistance,

r/David
0
Comment
Question by:yddadsjd95
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 7

Expert Comment

by:BusyMama
ID: 36473950
[txtRepairTotal].Refresh

I think will work
0
 
LVL 42

Accepted Solution

by:
dqmq earned 300 total points
ID: 36473952

me.refresh
docmd.requery
0
 
LVL 42

Expert Comment

by:dqmq
ID: 36473964
Perhaps I jumped the gun. What is the control source for txtRepairTotal?
0
 

Author Closing Comment

by:yddadsjd95
ID: 36474032
Thank you BusyMama for reaching out, but the code did not work.

dgmg, the control source for txtRepairTotal is the sum of the individual repair cost - =(Sum([RepairCost])), and your code did work. Thank you much.

Everyone have a great day and an even finer day tomorrow!

r/David
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36474042
you have to create a function that computes the total and call the function in the afterupdate event of
*service item
*associated cost
*existing cost
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question