Auto Populate a form field

[Jwy]

I have a form with fields "Assigned To" and "Assigned Date". When "Assigned To" receives a value, i.e. Not=Null, I want to auto-populate the "Assigned Date" field with the current date and time. How can I do this? Any help is appreciated.

 

[Pat Hartman]

In the AfterUpdate event of AssignedTo:

If IsNull(Me.AssignedTo) or Me.AssignedTo <> "" Then
    Me.AssignedDate = Now()
End If

 

[Jwy]

Thanks, Pat, you've been a big help.

 

[Jwy]

One more thing. Now I have a ProjectStatus combo box with several entries (UnAssigned, Assigned, InProcess, etc.) that I want to set to "Assigned" when I assign the project. Using your code above, I added:
Me.ProjectStatus = "Assigned"
...this does not work. Do I need to use the zero relative index to the entry in the combo box to set it correctly? Just a guess on my part. If you would be so kind as to show me the code required, I would appreciate it.

 

[Pat Hartman]

Are you really storing the text status or are you storing a numeric value? The combo may show the text value but it is likely that it is storing the numeric ID. In that case your let statement needs to use the ID of "Assigned" rather than the text.