Find Record (first Few Characters Of Key Word)

[wazza]

Hi

I have developed a form - with a text box for the user to input a character string.. e.g. "productZ" or "038482"

I am hoping to requery a list of records using the user search criteria..

Because the user will not always enter the exact character string - im thinking of basing the requery on the first few characters..
eg. get all records starting with; "prod"

I have wrote some vb to handle this - i just need to know the expression required for the SQL query. I have tried vartiations of LIKE but not retreiving any records..

cheers

 

[DJN]

Try this

Like [Forms]![YourFormName]![YourTextBoxName] & "*"

That should retrieve all records that start with whatever is in you text box