View Full Version : Form search function


mlamont
07-19-2001, 06:58 AM
I just ran into some problems with a form that is used for searches. It is a continuous form with the top portion used the search field and the bottom portion of the form is used to list all of the fields and data. When I search now I get this error message:

Function is not available in expressions in query expression 'Left([Primary Last Name],3)=[Forms]![CLIENT INFORMATION SEARCH - LAST NAME]![Last Name Search]"

I have never seen this error message, can anybody help me?

Rich
07-19-2001, 10:08 AM
Access sometimes throws up some obscure messages, assuming your form was working before try copying it and renaming it, make sure all your modules are compiled, or try importing everything into a new blank database.
HTH