setvalue not adding, it is overwriting

[phillipmai]

Hello,

I have created a Macro with three setvalues.

I have added this Macro to the event for onclick on a Tickbox but when I tick this box on the form it overwrites the record in the over form rather than Adding a new record.

What would cause this? the Data Mode is Add...

 

[phillipmai]

I no longer need help, just needed to add a line to the macro to close the form after adding.