Wanting to repeat previous recoud in a data entry form - automatically.

[RoyMcAvoy]

How can I get data from previous record to repeat in new record? I need my form to repeat=
certain data from previous records. I know that the shortcut command Ctrl+' will acc=
omplish this task. I want to know how to make it happen automatically.
It is a simple data entry form
=E2=80=A2 order type
=E2=80=A2 customer number
=E2=80=A2 item number =

=E2=80=A2 order qty.
I need the order type and store number to repeat after each order quantity is entered.=
I want then to move automatically to the next item number entry field.

 

[RuralGuy]

How can I get data from previous record to repeat in new record? I need my form to repeat certain data from previous records. I know that the shortcut command Ctrl+' will accomplish this task. I want to know how to make it happen automatically.
It is a simple data entry form
• order type
• customer number
• item number
• order qty.
I need the order type and store number to repeat after each order quantity is entered. I want then to move automatically to the next item number entry field.

Have a look here: http://support.microsoft.com/Default.aspx?id=210236
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Allen Browne]

Here's a couple more alternatives.

The first is to set the DefaultValue property of each control in its
AfterUpdate, so it is there automatically as soon as you move to the new
record:
Carry current value of a control to new records
at:
http://www.mvps.org/access/forms/frm0012.htm

The second is somewhat similar to the kb article posted by RuralGuy, but a
bit more generic. It fires on the first keystroke as you start the new
record, avoids overwriting the field the user is typing into, and assigns
the value to all fields except those you specify in the exception list.
Carry data over to new record
at:
http://allenbrowne.com/ser-24.html

This code looks a bit more involved, as it determines the field each control
is bound to, and avoids trying to assign autonumbers, calculated controls,
fields bound to calculated query fields, and so on. But it is still
plug'n'play code, i.e. you save the function and then use it in any form
with :
Call CarryOver(Me)