If trying to limit a combo list based on some value in another control, that will never work regardless of what event you use. Here's one of several ways this could be handled in the search criteria field After Update event:
Code:
Dim strCustomer As String, strSql As String
strCustomer = Me.txtCustomerSearch
strSql = "SELECT * FROM qryBudgetCustomerListDropdown "
If Not Nz(strCustomer,"") = "" Then
Me.cboCustomer.RowSource = strSql & "WHERE Customer = '" & strCustomer & "'"
Else
Me.cboCustomer.RowSource = strSql
End If
Me.cboCustomer.Requery
NOTE - it is assumed Customer is the name of the field you want to use in the query criteria AND that it is a text field and not a number. If number, the single quotes have to go.
Last edited by Micron; 06-26-2019 at 06:45 PM.
Reason: spelin and gramur
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.