Hi Jon
I will post a zip file in the forum but since it is for a family run business I'd appreciate it not going public.
For this purpose I have deleted the data from the "field invoice 2" table ( the main table for all data entry ) and then added two test records. The files that are created to feed into Excel are both in the zip file, names start
with - Export. The access code looks at two fields to decide which set of files to create (Call Source and East/West/central).
The "Parts-2017-03-09.xls" file is an excel file of parts prices used to populate the PART USED sub-form but this is not necessary
for our purpose. Or you can update the "linked tables" and it should jump in.
As you can see from the main form there are 4 types of reports for each of 3 locations giving 12 different sets of tables and queries.
(so we only need to solve 1 )
To recreate the error just enter some data into the "Data Entry" panel. Make "Call Source = PDP" and 'East/west/central = west" and
use tab key to navigate left-right and down. Fields with drop down boxes are required but (apart from the two already mentioned) values
are not important. The subcase box is mandatory, numeric - I usually use 8 or 9 digits all the same 11111111 22222222 etc.
the Parts Used subform can be populated using copy / paste from the spreadsheet below it. ( or just manually type into the fields )
the total Parts box below the subform is filled in by vba code . (Pink boxes are auto-filled, white boxes are completed manually)
There error pops up when you click on the "RECALCULATE" button to make sure all totals are complete. That drives the SUB Command159_Click code. If I comment out the flagged statement, then the record is created as shown bu the two examples. But without the totals I need). Here's the error: (box didn't copy but message is "Run-time error '244': You can't assign a value to this object.)
Hope this helps explain the process enough so you can figure out how to run it. It is easier to do than to describe I think).
Thanks again for you assistance.
Roy