?
Solved

How to get Access field to update immediately

Posted on 2013-12-21
3
Medium Priority
?
517 Views
Last Modified: 2013-12-21
I've added two date fields and a textbox that give the total days an animal was in a particular area of our operation.  (see attached)

The Foster days and Vet days field won't update until you close and reopen the form.  

How do I fix this?

Control source.  =DateDiff("d",[FosteredDate],[FosteredDateReturned])
asn.png
0
Comment
Question by:J.R. Sitman
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1600 total points
ID: 39734194
Seems it should. You can try putting a  Me.ReCalc in the AfterUpdate event of two dates involved in the total days calculation.

Private Sub FosteredDate_AfterUpdate()
    Me.ReCalc
End Sub


Private Sub FosteredDateReturned_AfterUpdate()
    Me.ReCalc
End Sub


mx
0
 

Author Closing Comment

by:J.R. Sitman
ID: 39734245
perfect.

Thanks
0
 
LVL 75
ID: 39734252
You are welcome. Keep up the good work with the animals :-)
mx
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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…
Suggested Courses

615 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