If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
After Update If
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/For...forms/201001/1 |
#2
|
|||
|
|||
After Update If
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/For...forms/201001/1 |
Thread Tools | |
Display Modes | |
|
|