Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / July 2007

Tip: Looking for answers? Try searching our database.

Look up last entry for text boxes or combo boxes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Fletcher - 17 Jul 2007 18:19 GMT
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 - 17 Jul 2007 18:56 GMT
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
resource@pcdatasheet.com

> Hello all,
>
[quoted text clipped - 11 lines]
>
> Fletcher.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.