Record Creating Automatically

[baskey]

HI ....
I have a database that I would like to create records in a table. I have 1 table called employees and 1 called training linked together as a one to many in a table called Level.
In the training table there is a field called "mandatory". When a new employee is added I would like it to create all records (blank) where "Mandatory =True". If anyone can help me I would be very very grateful....


kind regards
steveT_ Database.zip

[June7]

Could use INSERT SELECT sql action. Like:

CurrentDb.Execute "INSERT INTO Level(EmpID, TrainingID) SELECT " & Me.tbxEmpID & " AS EmpID, TrainingID FROM Training WHERE Mandatory=True"

[baskey]

Could use INSERT SELECT sql action. Like:

CurrentDb.Execute "INSERT INTO Level(EmpID, TrainingID) SELECT " & Me.tbxEmpID & " AS EmpID, TrainingID FROM Training WHERE Mandatory=True"

Many thanks for your advice June7
I tried to enter this into a query
INSERT INTO Level1(EmpID, TrainID) SELECT "Me.tbxEmpID & AS EmpID, TrainingID FROM Training WHERE Mandatory=True" but get error
"number of query and destination fields are not the same"...
Sorry I'm not to good with SQL !
Any further help please ?
cheers
steve

[June7]

What I showed is VBA code that executes an SQL action. The syntax is not correct for use in an Access query object.

[baskey]

Thanks June7....
I setup a command buttone to run the following code

Private Sub Command17_Click()
CurrentDb.Execute "INSERT INTO Level1(EmpID, TrainID) SELECT " & Me.tbxEmpID & " AS EmpID, TrainingID "FROM Training WHERE Mandatory=True"
End Sub

but just get error saying module not found ! Apologies for not being to good at this...
kind regards
Steve

[June7]

You show an extra " in front of FROM.