Hi Please see above code
Code:Private Sub Command2_Click() Dim sql As String sql = "SELECT [Titile] " _ & "FROM Alumni_List " _ & "WHERE [Given_Names] LIKE '*" & Me.Text0 & "*' " Me.Combo41.RowSource = sql End Sub
i am trying to fill a combobox based on values that is entered into a textbox, for example if enter "Mike" in Text0 then combobox should show his title upon a button click.
Hope you could help me on this.