duplicating and editing the record

[Airis]

Hi,
Have a great day. Please, could anyone advise me? I need to do in an Access form button (function), which duplicates the record in the database (table), changes in the amount of sign (from positive to negative amounts and vice versa) and throw this record with the current date. Would help me?

[Stressed]

Hi,
Have a great day. Please, could anyone advise me? I need to do in an Access form button (function), which duplicates the record in the database (table), changes in the amount of sign (from positive to negative amounts and vice versa) and throw this record with the current date. Would help me?

Good morning,

Take a look at my post from before. I think this is what you are trying to do.

https://www.accessforums.net/databas...time-4643.html

It's all based on a record ID.