Problem with Form 1

[noahaz]

I have this as my code
Private Sub Combo16_AfterUpdate()
If Me.Combo16 = "Completed" Then
Me.Date_Closed = Date
End If
End Sub

I have a form set up so that when a user selects "Completed that job dissapears from the form but is still in the table. However I have jobs that are completed but will not disappear when I choose completed. Completed is listed in my query. Can someone tell me what I am doing wrong?

 

[PHV]

You may try something like this:
If Me.Combo16 = "Completed" Then
Me.Date_Closed = Date
Me.Dirty = False
Me.Refresh ' or Me.Requery
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886