Parameter Value Issue from Search ComboBox

[pjd71]

I have searched and searched for a solution to my problem of opening a Query without having the form open first. The "Enter Parameter Value" started when I created a search box that searches from a Query. When adding the "Like" expression with Wildcard in the record source in the form FCP Requests, I get the Parameter Value when the form is not open and opening FCP Request Query.

I must not be getting the hang of this and was previously guided to add a "Where" expression. I don't have a clue on how to write it?

Help with this would be greatly appreciated to close out this project. DB is uploaded to view.

[June7]

The query already has a 'Where' expression - it is the criteria referencing the combobox. Open the query in SQL View and you will see the various parts of the query in SQL statement.

The query has a parameter that references a control on form. If the form is not open Access can't find the referenced item and will demand you provide a value. That's the way dynamic parameter works. If you want to open query without criteria input then can't have a dynamic parameter. There are other ways to navigate records on form, none of which rely on a dynamic parameter in query. I don't use dynamic parameters in queries. Options:

1. utilize the intrinsic Access filter/sort tools

2. code to filter the form RecordSource by setting Filter and FilterOn properties

3. moving to record using RecordsetClone and bookmarks

4. setting RecordSource property and requerying the form