Access VBA - use code to duplicate records in a table and then convert the values in a numeric field to negative
In Access VBA. I want to select a set of records from a table and duplicate them. I the want to change the positive number in the [Amount]
field to a negative value for the newly created records. What code would I use for that?