ACC97: Documentation Error in "OldValue Property" Help Topic (175961)



The information in this article applies to:

  • Microsoft Access 97

This article was previously published under Q175961
Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY

In the sample code in the Microsoft Access 97 "OldValue Property" Help topic that reads as follows, the last line before the End Sub statement (Next ctl) is incorrect:
   Sub btnUndo_Click()
      Dim ctlTextbox As Control
      For Each ctlTextbox in Me.Controls
         If ctlTextbox.ControlType = acTextBox Then
            ctlTextbox.Value = ctl.OldValue
         End If
      Next ctl
   End Sub
				

The correct code is as follows:
   Sub btnUndo_Click()
      Dim ctlTextbox As Control
      For Each ctlTextbox in Me.Controls
         If ctlTextbox.ControlType = acTextBox Then
            ctlTextbox.Value = ctl.OldValue
         End If
      Next ctlTextbox
   End Sub
				

Note that the correct syntax for the last line before the End Sub statement is Next ctlTextbox, not Next ctl.

REFERENCES

For more information about the OldValue Property, search the Help Index for "OldValue," or ask the Microsoft Access 97 Office Assistant.

Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kbprogramming KB175961