Copying last record info as defaults into new record

  • Thread starter Thread starter Steve Whitney
  • Start date Start date
S

Steve Whitney

(Newbie here; no experience with VBA, limited macro
programming, but pretty good with forms design, etc.)

Question:

What is the easiest way to populate a new record with
default values obtained from the most recent record added
(or maybe edited)?

We have numerous applications where we want to add a
series of records where each contains mostly the same
information as the prior record (multi-release orders,
production inspection records, etc.)

Can this be done without resorting to VBA programming?

If VBA is required, what is the proper method?

Thanks,

Steve Whitney
 
Steve,
You can do this manually or using code.
Manually:
With the record you want to copy active,
Click on the menu:
Edit + Select Record.
Then
Edit + Copy
Then
Edit + Paste Append

In code, code a command button click event:
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.Runcommand acCmdPasteAppend
 
Back
Top