Change code to search from"first part of field " to "any part of field"

  • Thread starter Thread starter mrmajix
  • Start date Start date
M

mrmajix

I have a form (InventorySearch) with a text box (txtEntry) which requeries
the subform (InventorySearchSubform) on change. The search expression is
linked to the field (Description). How can I change this code to search "any
part of the field" instead of the "first part of field". Thanks in advance.

Private Sub txtEntry_Change()
Me!txtSearchExpression = Me!txtEntry.Text & "*"
InventorySearchDetail.Requery

Exit_txtEntry_Change:
Exit Sub

Err_txtEntry_Change:
MsgBox Err.Description
Resume Exit_txtEntry_Change
End Sub
 
It appears you are using the Like statement in the parameter of the query to filter the
list. Placing a * in the front also should do what you want.

"*" & Me!txtEntry.Text & "*"
 
Back
Top