Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    2

    Unanswered: Passing value from a table into a form and saving into another table

    I have a form with the following fields:

    Date:
    Worked Hours:

    I have a query that has a default employee schedule for each day of the week. I need to be able to display worked hours for the date that is selected in the form, and allow the user to modify it and save the changes to table2.

    For instance, if I pick 9/21/2011 as the date, my query would know it's wednesday and the worked hours for wedneday is 80. So, it should display 80 in the form and I should be able to change that to 90 if needed and save the value to another table. Any input on how I could do that??

    Thanks for your time!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    If I were you I'd store it in the same table but as a different column (say adjustedhours). I would preserve the original
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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