Like "*" Criteria based from unbound form text box 1

[bddewell408]

I have a table named tblOffender which contains a field strLastName.

I am trying to create a query based off of a form named frmOffenderVerificationEntry which contains an unbound text box named LastNameSearch.

I need a query to return all Last Names from tblOffender when a partial name is typed, ie...

LastNameSearch field on frmOffenderVerificationEntry="sm"
Results:Small, Smith, Smooth, Smut, Smythe, etc


This is the current criteria I have in my query, and it does not work:

Like "[Forms]![frmOffenderVerificationEntry]![LastNameSearch]*"

I have also tried Like "'"&[Forms]![frmOffenderVerificationEntry]![LastNameSearch]&"'"

Thanks in Advance for any help
Bryan

 

[dhookom]

Like [Forms]![frmOffenderVerificationEntry]![LastNameSearch] & "*"


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]