This is very basic but it bothers me a lot that I can figure out why it is happening.
I have 2 different combo boxes on my form that get the result from 2 different queries.
My problem is that for getting the result to show, I have to pick it up from the combo box. It is not showing automatically, despite it is the only result from the combo. I hope that this makes sense.
One of them is NrOfInvoices. When the field CaseNo is updated, the query on the combo counts the nr of invoices with that CaseNo.
I have tried :
But I still have to choose the result from the combo. Same problem with the other combo that does a calculation..
Is it possible to get the result to show itself?
I have 2 different combo boxes on my form that get the result from 2 different queries.
My problem is that for getting the result to show, I have to pick it up from the combo box. It is not showing automatically, despite it is the only result from the combo. I hope that this makes sense.
One of them is NrOfInvoices. When the field CaseNo is updated, the query on the combo counts the nr of invoices with that CaseNo.
I have tried :
Code:
Private Sub CaseNo_AfterUpdate()
Me.NrOfInvoices.Requery
End Sub
Is it possible to get the result to show itself?