Code for CTRL+'

Is there a way perform CTRL+' with vba code in MsAccess 2000

Carbo

CTRL+' copies data from a field in the previous record to that field in the current record.

Use the .Copy function of the range object instead

VB Code:

'copy row 1 and paste into row 2
Workbooks(1).Sheets(1).Rows("1:1").Copy Destination:=Workbooks(1).Sheets(1).Rows("2:2")