Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013
    Posts
    5

    Unanswered: Time & Job Costing Database

    I am working a on database in MS Access 2007 to capture Time and Job Costing info. I started building a database using in split form but decided to change to a Main Form and Subform. My Main Form is EmpDate based on the EmpDate table. My Subform is SubCopy of Workhours based on Copy of Workhours table. I have it working almost the way I want but having one problem. When I click on the Save Button it doesn't pass the EmpID & DateWorked from the Main from to the Copy of Workhours table. How can I do this. I have attached a copy of the database.
    Attached Files Attached Files
    Last edited by ml3301; 05-15-13 at 20:08.

  2. #2
    Join Date
    Jan 2005
    Posts
    146
    Initially I would suggest you add EmpID & DateWorked to your Link Fields. This will automatically copy them at the time the record is created.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •