stealthassassin95
New member
- Local time
- Today, 21:39
- Joined
- Oct 15, 2012
- Messages
- 7
hi there;
i am trying to enter the date in a box of a form (in datasheet view) using a macro. as soon as the box is clicked, the date must be entered into the box.
i have been able to do this before using macros but i have forgotten how to do it! which action do i use when creating the macro?
currently i am using the SetValue action (not avaliable in access 2010) with the item "[Forms]![HILL]![DATE IN]" and expression "Date()".
i am using access 2010
im getting the error message "object or class does not support the set of events".
note: i do not know how to read or write VBA.
many thanks for any help in advance.
i am trying to enter the date in a box of a form (in datasheet view) using a macro. as soon as the box is clicked, the date must be entered into the box.
i have been able to do this before using macros but i have forgotten how to do it! which action do i use when creating the macro?
currently i am using the SetValue action (not avaliable in access 2010) with the item "[Forms]![HILL]![DATE IN]" and expression "Date()".
i am using access 2010
im getting the error message "object or class does not support the set of events".
note: i do not know how to read or write VBA.
many thanks for any help in advance.
Last edited: