By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Persistent data in Access 2003 forms

P: n/a
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

Aug 8 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Aug 8 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.