Fill Textboxes

[Eranka]

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

Hi Please see above code

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.

[GinaWhipp]

Hmm, doesn't look like you are requerying the Combo Box, I would add that line. I also see Titile instead of Title, is that what you have?

[June7]

That is an odd requirement. Why would you want a combobox with a single item in list?

Why don't you select Mike from combobox that has Title as column?

Are you really spelling Title as Titile in database?

[Eranka]

Hey

I'm sorry it should be Title, typing mistake,

Is there is anyway that i could return a value to textbox from a table based on a value entered into another textbox upon button click.

[June7]

A DLookup() domain aggregate function can do that. Usually better method is to use multi-column combobox to pull associated data to form.

[GinaWhipp]

You can but why? Is this just for display? Or are you wanting Cascading Combo Boxes. Just seems like you are trying to store a value that may not need to be stored.