Trigger in Access 2000

[FBU]

Hallo to everybody, I'm newbie of access 2000, I always used Mysql.
Now I have to make a trigger on a db of access 2000. It should work like this, when I insert a new record in table A the trigger have to insert other prefixed records in table B. How can I insert this trigger in Access 2000?
Thank you very much for your help
FBU

[MMcCarthy]

Hallo to everybody, I'm newbie of access 2000, I always used Mysql.
Now I have to make a trigger on a db of access 2000. It should work like this, when I insert a new record in table A the trigger have to insert other prefixed records in table B. How can I insert this trigger in Access 2000?
Thank you very much for your help
FBU

Access doesn't have triggers as such but if you have a form where the new record is being inserted you can code an event. For example on a button click event you can run an INSERT query to add a record to table B.

Private Sub btnName_Click()
Dim strSQL As String
 
   strSQL = "INSERT INTO TableB ([Field1], [Field2]) " & _
       "VALUES (" & Value1 & ", '" & Value2 & "')"
   DoCmd.RunSQL strSQL
 
End Sub
 

Please note that Value2 is enclosed in single quotes denoting a string.

Mary