Auto Fill with Date and Time

[Access_Novice123]

Hi, I'm new to Access and I'm trying to build a database to track the progress of document editing. I've made a form that will be filled out at different stages throughout the document's progression. The form contains drop downs and date/time stamps. There are different sections to be filled out at different times For instance:


Opened By -- Opened date, opened time
Content Review By--review date, review time
PDF By--PDF date, PDF time
etc.

What I'm trying to do is have the date and time fields fill automatically when the respective "Done by" field is filled in. I am using the code =IIf([Opened By]=True,[Opened Date]=Now()) in the date fields but it is not responding. Alternatively, if i set all the date time fields to default values Now() in the design view of the table of origin, all the fields fill at once instead of each stage being filled separately.

Is there a way to fix this? Thanks for helping a Newbie!

[pbaldy]

VBA code in the after update event of the Opened By field (inadvisable to have spaces in names):

If Me.[Opened By] = True Then
  Me.[Opened Date] = Now()
End If

[Access_Novice123]

Hi there,

Thanks for your reply. Unfortunately nothing happens when I try to put in this code.

[pbaldy]

Did you put it in the VBA editor in the correct event?

http://www.baldyweb.com/FirstVBA.htm

Has code been enabled or is the db in a trusted location?

[rpeare]

not sure what you're testing for but I'm assuming it's a value existing in opened by, but you would also have to check to see if the opened date is already populated, in other words you wouldn't want to overwrite a value if it was already present in opened date

if not isnull([Opened by]) and isnull([opened date]) then
    [opened date] = now()
endif

[Access_Novice123]

Thank you rpeare! I have no idea what that code means but it worked perfectly hah! Thank you so much!!

[rpeare]

isnull checks to see if a field is empty so conversely not isnull makes sure a field has *something* in it. You were checking for a TRUE value on a field that could not possibly yield a true/false or an expression that could be evaluated as true or false.