Me.

[Dave Smith]

hi, i have an expression "=Me.DateEntered=Date()" in the On Click event of a
button. I get the error message "The expression On Click you entered as the
property setting produced the following error: The object doesn't contain
the Automation object 'Me.'."

what does that mean?

thank you

Dave

 

[Rick Brandt]

hi, i have an expression "=Me.DateEntered=Date()" in the On Click
event of a button. I get the error message "The expression On Click
you entered as the property setting produced the following error: The
object doesn't contain the Automation object 'Me.'."

what does that mean?

The message might not be accurate because your syntax is incorrect. You have
two equals signs. Get rid of the first one and see what happens then.

Also, did you enter this into the event property box or in the VBA code window?
(it goes in the latter)

 

[Brendan Reynolds]

The keyword 'Me' is usable only within VBA code, not in expressions like
this. Try "=(Form.DateEntered=Date())" or just "=(DateEntered=Date())"
instead. (The outer parentheses in the above examples are probably not
needed, but they help to make the intent more explicit).