Copy information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make a button to copy all information entered by the user to a new
record then allow the user to correct one or two field of them how can i do
it??


I know there is a shortcut Ctrl' which can copy record,
however the user is disatify with it,
they request for a real button,
which when they click it,
it will open a new record and copy all previous entered information to the
new record.

for those information there is one generate random no. which will add 1 for
a new record.

how can i do this?
 
Use Button wizard >>Record operations>>Duplicate record.
If you cannot run the button wizard, copy the following code to your
button's On Click event:
'--------------------------------
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
'--------------------------------
 
really thx form help ~~~~~~~

Khoa said:
Use Button wizard >>Record operations>>Duplicate record.
If you cannot run the button wizard, copy the following code to your
button's On Click event:
'--------------------------------
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
'--------------------------------
Click to expand...
 
Back
Top