Today's date on a textbox based on combo box

[west]

Hello everyone,

I have a "Status" combobox, I'd like the "Date Case Closed" field to auto fill today's date when "Status" combobox = Closed. The way I know how to do this is by using an IIf with Date() function, but, if I do that, the date is gonna keep changing everyday.

Do I have options to do this?

-JC

 

[bob fitz]

Perhaps some code in the After Update event of the combo box, along the lines of:

If Me.ActiveControl = "Closed" Then
  Me.[TextBoxNeme] = Date()
Enf If

 

[west]

Thank you Bob it worked exactly the way you suggested here, only thing now is a little awareness for the users no to change the [Status] unless it is really necessary, because, if they change it by mistake there is no turning back or undo.

Thanks again

-JC

 

[bob fitz]

Thank you Bob it worked exactly the way you suggested here, only thing now is a little awareness for the users no to change the [Status] unless it is really necessary, because, if they change it by mistake there is no turning back or undo.

Thanks again

-JC

Not sure I understand your concerns but perhaps something like:

If Me.ActiveControl = "Closed" AND Not IsNull(Me.[TextBoxNeme]) Then
  Me.[TextBoxNeme] = Date()
Enf If