KeithG
AWF VIP
- Local time
- Today, 14:32
- Joined
- Mar 23, 2006
- Messages
- 2,592
I am creating an ubound form for data entry in the FE of my db. Once the user enters the data and presses the update button the form needs to add records to upto 8 tables. Is it more efficent to open up a recordset and use the add new method. Or use docmd.openquery to open an Append query to append the info? The table contain around 20,000 records so I assume that run the Append query would be more efficent than opening up a recordset for each new record.