i used the following method to save the history, Please check the below link.
I am able to save the history of one table records - but there is another one, which is not updating from the same form,
The function(to save history) is calling from the button submit(save), both original tables are updating with this submit button by running different queries.
And table A history is updating but Table B history is not updating.
Function call for table A history
, "audTmpInvoiceA", "audInvoiceA", "InvoiceAID", Nz(Me!InvoiceAID, 0), bWasNewRecord)
Function call for table B history
, "audTmpInvoiceB", "audInvoiceB", "InvoiceBID", Nz(Me!InvoiceBID, 0), bWasNewRecord)
Both function calls are after the corresponding query updates.