I have a table (table2) that has fields to hold another tables ID (table1) and a currency total.
From a form that relates to the table1 ID, I want to click a button that then totals all of the currency fields from table2 that have the same ID as in table1. The total then is to be inserted into a grand total field in table1.
I have a query that does this, but don't know how to run this in vba and to extract the grand total figure from the query result.
I have also tried to run a for, next routine, but get into difficulties in addrssing the table.
Can anyone help please?
regards
Swarland