- Local time
- Today, 14:22
- Joined
- Oct 29, 2018
- Messages
- 21,467
Hi. I looked over the referenced 2008 article on TechRepublic and tried to download the sample database but couldn't. It would have been nice to see it in action. However, I tried to duplicate the functionality in your database, not using the exact same technique shown in the article, but in the way of how I understood the approach being described in the article. Unfortunately, it didn't work as I had hoped - that's why seeing a sample database would be nice. If anyone can download the sample database, please share it here. In the meantime, I have attached my attempt in case someone can see what I was missing to make it work. Open the form "frmDemoSingle." Cheers!So the code I'm using is more or less lifted from that article. I believe the recordset is connected initially in order to populate it, then it's disconnected. Then it's updated via the code she has on the form. Then the recordset is re-connected to the table. Then she runs UpdateBatch to write the changes to the table. Through testing, I can see that my subform successfully modifies the data in the recordset. The reconnection also appears to work. But UpdateBatch doesn't do what it ought to do.