I have created the following append query:
INSERT INTO tblAuditMsg ( MsgID )
SELECT tblMsg.MsgID
FROM tblMsg;
I have tested it and it appends (inserts) 14 records into tblMsg. However, what I would like to know is What are the steps to setup and run this query in my Subform?
- Basically, for every Main form record i create I would like this Query to be executed/run for my Subform (i.e. create 14 records).
- Where do i insert this code in the Main or Subform? and is this the correct script and/or scripts to make this all come together?
Any help with this would be great, thanks.
Thanks