The Me operator should be used to refer to controls on the form or report in which code is running. In doing so, using "." rather than "!" after Me helps catch compile time errors. Otherwise, the errors are only discovered when the application is executed. For example:
Use | Me.txtLastName |
Instead of | Forms!frmPerson!txtLastName |
Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.
Darren D.
All Our Microsoft Access Products