Look up last entry for text boxes or combo boxes

[Fletcher]

Hello all,

I'm consolidating some data that my company has accumulated and many
of the peices of data carry over to the next entry many times over.
In other words, many entries may have duplicate peices of data, i.e.
location, country, building, etc... I would like to make it so that I
can have some of my combo and text boxes remember what was last
entered so I don't have to retype it every time.

I thought that I had seen something like this before, but after a
morning of searching and reading I have decided to post.

Thanks in advance,

Fletcher.

 

[Steve]

This was answered earlier --
Put the following code in the AfterUpdate event of your control:
Me!NameOfYourControl.DefaultValue = "'" & Me!NameOfYourControl & "'"

The control will "remember" the last entry for as long as the form is open
but "memory" will be lost when the form is closed.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)