hello everyone
ive just created a search page in a form, which searches by creating querys. I want it to work so that the user only has to type part of the record in order for the results to be displayed. This does work but you have to write your search from the beginning letters of the record, rather than anywhere.
Here is what I put as a criteria in the query
Like [Forms]![searchallform].[ftapeno1] & "*"
What do I need to change in order for it to do what I want it to do?
cheers guys
ive just created a search page in a form, which searches by creating querys. I want it to work so that the user only has to type part of the record in order for the results to be displayed. This does work but you have to write your search from the beginning letters of the record, rather than anywhere.
Here is what I put as a criteria in the query
Like [Forms]![searchallform].[ftapeno1] & "*"
What do I need to change in order for it to do what I want it to do?
cheers guys
