Append records to table using variable on form

[Herdrich]

I have a database that keeps track of employee training completion and due dates and im trying to figure out how to append a new training record to everyone’s record in the database. what I have now is if a new user is created a template is put into their record with all of the required training. The problem that im having is that the type of training everyone needs sometimes changes and i want to be able to add it to people that are already in the system

I have everyone’s information listed in the PersonnelMain table I want to pull the SSN from there then use the data from Me.Combo14 for the training type then use Date for DateCompleted and DateDue. I just cant figure out a route on how to do this any guidance would be awesome

PersonnelMain.SSN = *, Type = Me.Combo14, DateCompleted = Date, DateDue = Date

 

[PWise]

put a command button on the form and run this code on the click

currentdb.execute "insert into Traingtable (SSn,Type,DateCompleted,DateDue)"
Select PersonnelMain.SSN, " & Me.Combo14 & ",Date(),Date()
From PersonnelMain

 

[Herdrich]

Having a bit of trouble getting this to run i found this

http://www.1keydata.com/sql/sqlinsert.html

witch talks about what you gave me but i cant get it to run tried it the way you had it this way and without the currentdb.execute still no luck.

CurrentDb.Execute INSERT INTO "Training" ("SSN", "Task", "DateCompleted", "DateDue")
SELECT "PersonnelMain.SSN", '" & Me.Combo14 & "', Date(), Date()
From Training

I get an expected end of statement on "Training" for the first line and expected case for "PersonnelMain.SSN

 

[Herdrich]

Last line of code is actually

From PersonnelMain

 

[Herdrich]

Well guess i asked too soon figured it out

CurrentDb.Execute "INSERT INTO Training (SSN, Task, DateCompleted, DateDue) SELECT SSN, '" & Me.Combo14 & "', Date(), Date() From PersonnelMain"