code to find name of last updated field

[Guest]

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?

 

[Carl Rapson]

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?

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