using wildcards in a string query

[fratezone]

I need some help in completing the following. I've been trying several ways but to no avail.

Where do I add the wildcard "*" if I want to the query to come back with records including "LOUISI" (for Louisiana)or whatever is entered or selected in the combobox.

If Not IsNull(Me!cboState) Then
strFilter = strFilter & " [CityState] = '" & Me!cboState & "' AND"
End If


Any help would be appreciated.

 

[GKite]

In the actual query, under the criteria section of the field [CityState], put:

Like Forms![formname]![cboState] & "*"

Thats how I handle this type of situation.