If then stament in VBA

[roles40]

Sorry for the horrid question, but I can't seem to figure this out. I have a combo box that has two values in it, pending and completed. I want a text box to update to the current day when the value in the combo box is changed to completed. This is all on a form by the way. I tried to use the OnChange event procedure, but couldn't figure out how to say in VB

if (IssueStatus = 'Completed') then
DateComp = Date();

so if anyone can help, you would be appreciated greatly.


Thanks in advance!!

Jamie

 

[BillPower]

Try the After Update event of the Combo "IssueStatus ":

If Me!IssueStatus = "Completed" Then
Me!DateComp = Date
End If

Bill

 

[roles40]

Bill,

thanks for the code, works great.

u da man

Thanks!!!!

Jamie