Can someone tell me why the 'Name' field in the 'Gift_Totals' table is being updated with the last value of the "Recreate Totals" report that was displayed ? Only the first record for the 'Name' field in the 'Gift_Totals' table is affected. The name is selected from the 'Listbox'. Below the 'DoCmd' commands used.
DoCmd.OpenReport "Re-Create Report Gifts", acViewPreview
DoCmd.Close acForm, "Recreate Totals", acSaveNo
A 'Test' database is attached.:banghead:
DoCmd.OpenReport "Re-Create Report Gifts", acViewPreview
DoCmd.Close acForm, "Recreate Totals", acSaveNo
A 'Test' database is attached.:banghead: