Solved

How to get Access field to update immediately

Posted on 2013-12-21
3
498 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 400 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Null or "" 28 52
What are my options to share data with field staff 16 50
access to sql migration 5 23
Display Excel gridlines when called from Access 7 10
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

756 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