Solved

Insert Today's date in one field based on the value of another

Posted on 2011-03-14
4
418 Views
Last Modified: 2013-11-28
I have a tracking database and I want to make it so that when the person marks the "status" field "completed" it inputs today's date in the "datecompleted" field.  How do I do this in my form?
0
Comment
Question by:dcmennealy
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
ErezMor earned 125 total points
ID: 35133704
you use the "AfterUpdate" event of the status field to :

if status="completed" then datecompleted=Date()

(the above is as plain as you described the scenario, meaning the status field is string that may receive the sting "completed")
0
 

Author Comment

by:dcmennealy
ID: 35133960
Thanks, it worked!
0
 

Author Closing Comment

by:dcmennealy
ID: 35134061
I am new to VBA and this was very simple and useful
0
 
LVL 12

Expert Comment

by:ErezMor
ID: 35140731
you are most welcome to ask further
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

930 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now