How to update a combobox selection from a text box?

[Shankar14]

Is it possible via VBA to select an item from a combobox drop down where the value is from an input text box?

Using VBA option 'after update', Is it possible to redefine combobox row source if already bound ?

 

[GPGeorge]

"Is it possible via VBA to select an item from a combobox drop down where the value is from an input text box?"

Yes.

"Using VBA option 'after update', Is it possible to redefine combobox row source if already bound ?"
Yes.

Now, if you want some examples of HOW to do those things....
Really simplistic approaches:

Private Sub txtInPutBox_AfterUpdate()

Me.ComboBox = txtInPutBox

End Sub

Unfortunately, "Using VBA option 'after update'..." isn't enough to go on. "After update" of "what" matters here.

 

[Eugene-LS]

Using VBA option 'after update', Is it possible to redefine combobox row source if already bound ?

Yes, it is possible.

Dim sRowSource As String
    sRowSource= "Select ... From ... "
    If Len(Me.txtFild & "" > 0 Then
        sRowSource= sRowSource & " Where [Your fied name] = '" & Me.txtFild & "'"
    End if
    
    Me.ComboBoxName.RowSource = sRowSource