Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Modified problem 1

Status
Not open for further replies.

ALNG

Technical User
Joined
Mar 5, 2002
Messages
5
Location
US
I have looked at thread702-1012686 and tried the solution given. When I use Me![Modified] = Date() in the BeforeUpdate event, I get an error saying the macro is not found. When I use =Me![Modified].Value = Date(), the brackets get added =[Me]![Modified].[Value]=Date() and I get an error stating The object does not contain the Automation Object 'Me.' when I try to update a record in the form.

Any help would be appreciated.
 
You are adding it in the property window.
You need to add it into the code window.
click on the ellipse [...] button at the right hand side of the BeforeUpdate Event you will be taken to the code window like below
Code:
Private Sub cboMonths_BeforeUpdate(Cancel As Integer)

End Sub
add you code in between the lines.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.
 
That was it. I do appreciate it. Guess I am way out of practice.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top