>>> designing the algorithm to be implemented in your program that usually eats your socks for you
Yes I know what you mean. I recently answered and OP's question.
"Repeat Subform last field entry x amount of times using command button"...
The OP wanted to add 5 copies of a Row in a subform. I automatically did it my preferred method. Standing back and looking at the problem the next day, I realised it might be something I could code in a generic way, meaning that it would work for any subform.
Looking at my original solution, I realised it would be difficult to make it generic. I thought, maybe there's a simpler way. I usually find SQL statements are quite simple from the point of view of making them generic. They are basic text elements which can be taken apart and recombined easily within a VBA function. I also have available previously written code for manipulating SQL statements.
I did some research and found that the SQL "statement insert into select" would probably be ideal. see HERE:-
"INSERT INTO SELECT"
I provided a simplified answer to the question using this method, and at the same time gave myself a good basis for making a generic solution.
It's all done and dusted! (The generic solution) Works lovely. Really satisfying process --- chuffed with myself!
I intend making the generic solution "AddSubformRecords_1a.accdb" available via the
freemium business model, once I figure out how to setup and use WordPress for selling digital products. I used to use Payloadz but they started charging around $30 a month, and I wasn't selling enough stuff to justify that sort of fee.
