Using Like"x*" in query based on a form

[DRH192]

Hi,

I am trying to build a query that uses the Like function. I want it to be based on the text that a user types into a text box on a form so I have ....

Like "Forms![frmSearchReturns]![PropNum]*"

I have tried a load of other ways of writing it but nothing seems to bring back a result.

Any help would be much appreciated.

Cheers

Duncan

 

[PHV]

And this ?
Like [Forms]![frmSearchReturns]![PropNum] & '*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886