Parameter Prompt keeps on showing up?

[ki2n]

I'm using Access 2010, and I'm creating a navigational form with subforms. I have a search subform inside with multiple fields selectable by option buttons. I have the associated queries set up that would run the search in the background (and the forms would show the results of the queries). When I press the Search button (that I've created with the Macro Builder that would open the forms), it would just ask for the value of the field textbox, even when it's already filled in.

 

[CJ_London]

sounds like you are not referencing your textbox correctly - try using the query builder to reference the textbox and compare the code with what you have

 

[ki2n]

The query works on the search form by itself when not in a navigation form. But when I use the same search form as a subform under a navigation form, it asks me for the value of the textbox, even when I filled it in.

I've checked the references - The query is the only thing that has a reference to the textbox in the search form. The button has a macro that just opens the form that runs the query.

 

[CJ_London]

If you are testing it as just the search form and then put the search form in as a subform into your navigation form then it is a subform, not a form. So you are not referencing your textbox correctly - you need to reference the navigation form and then the subform.

You might be better to add the criteria to the docmd.openquery WHERE parameter

 

[ki2n]

Okay, that part works. Thank you.

Now I have another question about the same search form - I'm making this search form search up two forms - one of which is working now. The other I'm trying to use the search form to search up a criteria, but within the search results, display all the fields that are associated with it.

Like say, I have a table of customers, and I want the search form to look up by name, and the results will show up with the customer name and other customer details that exists within the record. Is that possible? I've tried it, and all I've been getting are empty records as the result.

 

[CJ_London]

Please post this to a new thread since it is not relevant to the current one