Copying last record info as defaults into new record

[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

 

[Fredg]

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