Undeclared Parameter

Adopotato

New member
Local time
Today, 11:02
Joined
Jun 19, 2013
Messages
2
I very new to Access. I am using the Contact Database template from MS and added a field of text. I am trying to get a query to search the field for partial text. I've typed the following parameter to help narrow it down because I only need partial information:

Like "*" & [How are the contacts involved in Organization?] & "*"

I used the query builder off of a report that was already created. I just want to be able to get contacts on the report that match the parameters inputted into the box.

When I run the report it gives me the following error:

"You either have an error in your expression or you have attempted to use an undeclared parameter. Check the expression for errors or enter the parameter '[How are the contacts involved in Organization?]' in the Query Parameters dialog."

I hit OK and it pulls up the report without data filled in.

I am unsure of where the problem is.

Any help is appreciated!
 

Attachments

  • parameter1.JPG
    parameter1.JPG
    80.5 KB · Views: 225
  • parameter2.JPG
    parameter2.JPG
    90.5 KB · Views: 185
  • parameter3.JPG
    parameter3.JPG
    97.6 KB · Views: 189
I would suggest to not use a parameter prompt but instead use a form for input. It will be more efficient and less annoying to the user should they type something incorrectly and they hit enter at which time they would realize that they need to run it again and then type what they need again. Use forms for parameters and then it becomes much easier.
 

Users who are viewing this thread

Back
Top Bottom