Requery fields

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top