Persistent data in Access 2003 forms

[Scott.Ashby]

Everyone,

I have a form which is bound to a table. There are about 10 fields on
the form, and my users would like for all but 2 of the fields they
enter on this form as part of a new record to persist on the form
(like default values) for the next record. I have to be overlooking
something... Is there a property on the field that I can set to allow
the field values entered to be carried over to the next record?

Thanks in advance,

Scott

[fredg]

On Tue, 07 Aug 2007 18:53:44 -0700, Sc*********@SMNA.com wrote:

Everyone,

I have a form which is bound to a table. There are about 10 fields on
the form, and my users would like for all but 2 of the fields they
enter on this form as part of a new record to persist on the form
(like default values) for the next record. I have to be overlooking
something... Is there a property on the field that I can set to allow
the field values entered to be carried over to the next record?

Thanks in advance,

Scott

Why not just make each new entry the default value for the next record
entry.

Code each control's AfterUpdate event:
Me![ControlName].DefaultValue = """" & Me![ControlName] & """"

If the control field is a DateTime datatype, use:
Me![DateField].DefaultValue = "#" & Me![DateField] & "#"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail