Repeating data input, Access 2003

[Beatle, lost.]

Hi All,

I need help on how to setup auto repeat entry in a form with in Access 2003,
I know I can press CTRL + ' will enter in the data from the previous record.
But I can not find anywhere how to do this automaticly within the properties
of form text boxes & combo boxes.

Please help as I have lots of data to punch in with a number of fields being
the same.

Thanks.

Sean.

 

[Allen Browne]

See:
Assign default values from the last record - Carry data over
at:
http://allenbrowne.com/ser-24.html

The article explains how to set up your form so that the boxes fill with the
same value as the last record in the form, at the point when you being
adding a new record. Unlike the Duplicate Record wizard, it recognises
unbound controls and those bound to expressions or calculated query fields
(as well as the autonumber) and does not try to duplicate those. You can
also specify exceptions (fields that should not be copied.)

If you just wanted to duplicate one or 2 fields, here's another approach:
Carry current value of a control to new records
at:
http://www.mvps.org/access/forms/frm0012.htm
This one works by setting the Default Value of the controls, so uses the
last edited record rather than last record.

 

[Beatle, lost.]

Hi Allen,

Followed your instructions for coping the code and event. but when debugging
the code in module 1 I get the following error.

Compile error:
User-defined type not defined

This is the line it is stopping on.

Dim rs As DAO.Recordset 'Clone of form.


Thanks in advance for your help.

Sean (beatle)

 

[Allen Browne]

You need to add a reference to the DAO 3.6 Library.
This reference is natively there in all versions of Access except 2000 and
2002.

More info:
http://allenbrowne.com/ser-38.html

 

[Beatle, lost.]

Thank you Allen,

I have it working now. It was the DAO36 link. great to see other helping
when they can

Thank you again with your help....

Sean (Beatle)

 

[Jamie Collins]

You need to add a reference to the DAO 3.6 Library.
This reference is natively there in all versions of Access except 2000 and
2002.

I think you meant to say, "This reference is natively there in Access
2003".

Access 2007 has a reference to 'Microsoft Office 12.0 Access database
engine Object Library', Access97 had a reference to DAO 3.51, ... ;-)

Jamie.

--