Me.

D

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
 
R

Rick Brandt

Dave said:
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?
Click to expand...

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)
 
B

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).
 
Top