Duplicate record on focus

[kdankwah]

Could someone please give me a script to duplicate a record on focus after entering the data on the last field. I have a duplicate button script that has this script that I got from the help section. Below is the script attached to the button.

topparent.duplicate_record(1)

but anytime I click on the button I get this message that says "you must be in view mode to duplicate the current record".

I am using this button to speed up dataentry. I am using A5v7.
It works when I click on the next page arrow and come back to press the button. My belief is that I get the message because at the time I press the button the data is not committed to the database. How do I do the commit and at the same time get the duplicate record when the button is pressed.


Thanks

[Tom Cone Jr]

topparent.commit()
topparent.duplicate_record(1)

[Mike Wilson]

I have had problems with the duplicate_record() function. I believe it was Cal Locklin that recommended this method, which has always worked well for me, since.

tbl = table.current()

record_data = tbl.record_data_get()
target = table.open("Yourcurrenttable")
target.enter_begin()
target.record_data_set(record_data)
target.enter_end(.T.)

' this section if you want to amend certain elements of the duplicated record
target.change_begin()
	target.field1 = value1
	target.field2 = value2
target.change_end(.t.)
' end of amend segment

target.close()

topparent.resych()
topparent.refresh_layout()

[kdankwah]

Thanks to you both.

K

[AlliChavez]

I am having this same issue but I cannot get anything to work