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 / May 2007

Tip: Looking for answers? Try searching our database.

code to find name of last updated field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Miranda - 10 May 2007 18:06 GMT
I have a form (frmDataEntry) with several text boxes to score product
attributes with a score of 1 to 3.  I have code to open a new form
(frmLowScoreComment) if anything less than 3 is entered in any attribute.  
frmLowScoreComment has two fields, a comment field and a text box for the
name of the attribute that caused this form to open.  I want the attribute
text box to be filled in automatically, but can't seem to find code to do it.
I know how to create one for each attribute, but just can't figure out how
to get it to look at the last text box that was updated/exited.  Any help out
there?
Signature

Miranda

Carl Rapson - 10 May 2007 22:38 GMT
>I have a form (frmDataEntry) with several text boxes to score product
> attributes with a score of 1 to 3.  I have code to open a new form
[quoted text clipped - 7 lines]
> out
> there?

Pass the name of the control to frmLowScoreComment in the OpenArgs parameter
of OpenForm, then pick up the value in the Form_Load event of
frmLowScoreComment and populate the text box with the name.

Carl Rapson
 
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



©2009 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.