Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Entering the same data into 2 fields on a form

    I am setting up a database to monitor the progress of projects. For each project I have an "initial estimated completion date" and a "current estimated completion date". At the start of a project I want to be able to enter the "initial estimated completion date" and also, without having to re-enter the data, assign this date to the "current estimated completion date" as well.
    Subsequently the "current estimated completion date" would be updated as the project progressed and we would be able to compare this date to the date we originally estimated.
    Hope you can follow that, what is the best way to acheive this?
    NB There are actually lots of different stages to each project with initial estimated dates and current estimated dates so entering the data twice would be quite time consuming.
    thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Simply use the AfterUpdate event of the Initial Estimate controls to copy the value to the other control.

  3. #3
    Join Date
    Feb 2009
    Posts
    14
    If you only want to copy the date on the 1st data entry (specifying estimated completed date), you could add code to in AfterUpdate to only copy if the field/control is empty, therefore subsequent data entries would not change the estimated date.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Fields - No Data
    By tempowls21 in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:12 AM
  2. Replies: 0
    Last Post: 01-24-2009, 11:40 AM
  3. can't enter data in some form fields
    By ashiers in forum Forms
    Replies: 1
    Last Post: 09-18-2008, 12:37 PM
  4. Replies: 1
    Last Post: 08-04-2008, 03:30 AM
  5. Entering query results in a form
    By marcello.dolcini in forum Forms
    Replies: 0
    Last Post: 04-15-2007, 06:01 PM

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