L
Lars Brownies
In field Date_ready I have the following code:
Private Sub Date_ready_DblClick(Cancel As Integer)
If IsNull(Date_ready) Then
If MsgBox("Close this request?", vbQuestion + vbYesNo, "Close") = vbYes
Then
Date_ready = Now
Status = "Ready"
DoCmd.RunCommand acCmdSaveRecord
cmbOpenRequests.Requery
fldNrOfOpenRequest.Requery
End If
End If
End Sub
cmbOpenRequests is a combo with muliple fields regarding the pending
requests (based on the fact if Date_ready is filled or not)
fldNrOfOpenRequests is a calculated field that shows the number of pending
requests (based on the fact if Date_ready is filled or not)
The strange thing is that if I close a request by double clicking, the
aforementioned fields aren't updated. Does someone have a clue what I'm
doing wrong?
Thanks, Lars
Private Sub Date_ready_DblClick(Cancel As Integer)
If IsNull(Date_ready) Then
If MsgBox("Close this request?", vbQuestion + vbYesNo, "Close") = vbYes
Then
Date_ready = Now
Status = "Ready"
DoCmd.RunCommand acCmdSaveRecord
cmbOpenRequests.Requery
fldNrOfOpenRequest.Requery
End If
End If
End Sub
cmbOpenRequests is a combo with muliple fields regarding the pending
requests (based on the fact if Date_ready is filled or not)
fldNrOfOpenRequests is a calculated field that shows the number of pending
requests (based on the fact if Date_ready is filled or not)
The strange thing is that if I close a request by double clicking, the
aforementioned fields aren't updated. Does someone have a clue what I'm
doing wrong?
Thanks, Lars