Prev: CONTROL PROPERTIES VISIBLE = NO (HIDING CONTROLS)
Next: Memo Field Limited to 256 Characters?
From: The Joker via AccessMonster.com on 8 Jan 2010 13:37
Hello All,

I have a combo box on a form (frmTaskDetails) that has the status of the
current task open and a second field that has Completed Date. I'm looking to
have the Completed Date automatically populate with Date() if the user choose
Completed in the Status combo box. How would I go about doing this? My
thought was in the After Update but everything I'm trying is not working. I'm
trying to avoid validation rules if possible since it seems you can't control
the message it pops up with.

Thank you!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201001/1

From: Linq Adams via AccessMonster.com on 8 Jan 2010 14:05
Private Sub StatusCombobox_AfterUpdate()
If StatusCombobox = "Completed" Then
Me.CompletedDate = Date
End If
End Sub

Replacing names as appropriate, of course.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201001/1

 | 
Pages: 1
Prev: CONTROL PROPERTIES VISIBLE = NO (HIDING CONTROLS)
Next: Memo Field Limited to 256 Characters?