GoTo last record, copy it, and create new record

[dj59]

'Go to last record in table1
DoCmd.GoToRecord , acLast


'copy last record (row) in table1


'insert last record as new record with one value changed


So last record in table looks like this:

and new record in the same table looks like this:

Thanks

 

[jscranton]

Your images aren't viewable (at least for me)? Can you post them as text?