Preautopopulate Form record

[JaneM]

How do I create a new record in a form copying (autopopulating) data from the
previous record? I already have created three forms. Would I have to redo
forms? Is this possible? Would I need to use code?

 

[Jeff Boyce]

Jane

You've described "how".

Now, "why?" What would having a new record that was an essential duplicate
of the previous record allow you to do?

(often when folks are trying to copy a previous record it is because they
are used to working in Excel rather than Access).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Yup, I've used the DefaultValue approach to carry values forward into new
records, and only for a limited number of controls.

Without more information, it's hard to offer more specific suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

True, Jeff! Just had a conversation elsewhere, today, noting that those of us
who answer questions on a regular basis spend at least 25-30% of our time not
***solving problems*** but rather trying to find out, from the OPs, ***what
the problem actually is***!

In my experience, that applies in all areas of life, not just technical.
Correctly identifying the problem is not only essential - often, just (clearly
and correctly) stating the problem makes the solution obvious.

Reviewing some of the longer threads in these groups makes it clear that many
problems here don't get stated clearly... and indeed could be solved in
moments if they were!