Recent content by twinfair

Its fine and why I was doing it all in a test database :). Thanks for your help.

Thank you for your time. Unfortunately it didn't work at first. I ran it after amending a few field names which I may have confused you over and it seemed to hang. I killed Access and when I went back to it, it had added 716,043 records all identical ie a copy of the first record. I did an...

This is the code for the button on the Table1 form. Table2 is ID (Autonumber key field), Master, Detail and Value. TableB is the same plus some more fields. The Master field is the link to the other tables and in TableB will need to reflect the newly created record in TableA. Private Sub...

Thank you, that is what I hoped to be able to do but my problem is I don't know how to do this. I am not sure what the syntax is of the command to create the filtered recordset and then I am not sure how I loop to add the new records.

I am self-taught in Access so am not always familiar with technical terms but this is what I have and want to achieve. I have 4 tables: Table1, Table2, TableA and TableB. Table1 is effectively a master table with Table2 being a sub-table (one to many) with an appropriate linking field (lets...