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

    Unanswered: Macro to Copy Record Field content to another Table Recod

    I'm not an expirienced Access user, but I've contrusted a database that's used for scheduling production equipment and employees.

    The database has 3 main parts
    1) Training Records for all employees
    2) All the lines and what their producing for the week
    3) All the personnel required to run the lines

    The issue i'm having is getting information from one subform to the next.

    Click image for larger version. 

Name:	access.png 
Views:	4 
Size:	50.0 KB 
ID:	17118

    The main form allows me to select positions by PositionID (al-1 mech, al-1 op,...)
    Then subform1 is a table that filters all qualified employees eligible for the position like an active query.
    Once a record in subform1 is selected (which is a person's name), I'd like to click a button and have that field data (employee's name) paste into subform2 in the same positionID under the A Crew Field.
    Click image for larger version. 

Name:	access BREAKDOWN.png 
Views:	3 
Size:	70.9 KB 
ID:	17120

    Can someone help me with the VBA code to do this? If possible, please explain the code because I'd like to learn to use it for later and not have to ask.

    Thanks very much for taking the time to read this and help.
    Attached Thumbnails Attached Thumbnails access BREAKDOWN.png  

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    472
    Provided Answers: 22
    You don't need vb.
    Anything involving data,use a query.
    Add records with an append query.
    Change records with an update query.

Posting Permissions

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