Carry over to new record on form

[John Sawyer]

Hi, I was reviewing other postings and reading tutorials and nothing seems to
work. I had one trial that proved semi-successful:
www.istraining.bham.ac.uk/documents/acc0007.doc

They make you set the afterupdate values using an unbound textbox that can
be hidden. That saves the value after the update and reapplies the value to
the original textbox. The interesting thing is it only operates properly
after you have played around with the code. I've closed the database and come
back. It brings back the original data from the previous entry, but not the
previous entry from every new entry (ie. I put John down for name and 22 for
Age, and I have another John that is 23, the third time I try to enter it
will bring up John and 22 again.) I have it clear out the memory from the
unbound box (which is hidden) within the afterupdate code. However, it
operates properly if I look at the event procedure of either one of the entry
fields (or more, I have about 6 of them total).

I'm extremely confused by this and I will attempt to explain this further if
need be.

Thanks in advance!

 

[Larry Daugherty]

You've been sent on the right track but maybe your expectations aren't
in line with what will actually happen. I recommend that you go to

www.mvps.org/access and search for CQUOTE

That will explain how to change the default values for specific
controls during the current form session. Changes will not persist
across form sessions nor Access sessions unless you actually go into
design mode each time.

HTH