Kailash - Auto Date

  • Thread starter Thread starter FroGG
  • Start date Start date
F

FroGG

Sorry Kailash,

I dont understand what you mean by pseudo code.

My fields are User ID and Date Actioned.

Do I substitute your response:

sub myField_afterupdate
myotherfield = now()
end sub

as follows:

sub User ID_afterupdate
Date Actioned= now()
end sub

I tried the above and received an error stating expected end in line User
ID!
 
The reason for the error is the space character. Its not a valid character
in VB even if you name controls in access that way

The best way to do this from the form. In design mode view the properties of
UserId and in the events tab look up the AfterUpdate property and create the
code for it by choosing code builder. This will take you to the VB editor.
Then you set the date from there..
date_actioned = now()
 
Back
Top