query for alpha select

[John]

I have a main form and on it is a combo box. I also have
a button that displays a small popup form with the buttons
for each letter of the alphabet. I am making it so the
user can reduce the list in the combobox to only those
that start with the letter of the button selected from the
popup form. When the alpha button is selected and form
closed, the RowSource of the combobox is changed to the
letter the user selected. Below is the SELECT statement
but the WHERE is not working. So I'm needing a how.
Anyone see what I am placing incorrectly?

"SELECT " & _
"ClientID, " & _
"ClientName, " & _
"ClientDBA, " & _
"ClientCode " & _
"FROM usrtblClientInformation " & _
"WHERE (((ClientName) LIKE '"A & *')) " & _
"ORDER BY ClientName ASC;"

Thanks to anyone who responsds.
*** John

 

[John]

Disregard this posting. I just got it figured out.
*** John