Copy Query Results to Table (add)

[OBP]

I thought you might be an Excel user due to your terminology.
The query with module works OK with the form, but I can't get the public variable to reset to zero if you want to run the form again with a different query parameter.
Is the database that you posted the basic design you are working with?
As you seem to be carrying out duplication that may or may not be necessary.

So how do you intend to use the Balance form? will you manipulate the data more than once?

Have you considered a Tabbed form rather than a menu, as it is more like EXcel to work with?

ps Looking at your table designs you do not need the Balance table as you can work with the DDR table, unless you are going to clear the DDR table for some reason.