Search Form - Dialog box asks for search criteria

[faythe1215]

Currently working on a search form. I started by following the instructions outlined in this post:



https://www.accessforums.net/access/...7-a-26373.html

The form used for the search is a subform. The main form contains a button that makes the search subform visible. When I try to open the main form, a dialog box appears asking for the search criteria. I was under the impression that placing default values in my text boxes (in the search form) would keep this from happening.

[June7]

That tutorial does not involve form/subform arrangement.

Be aware that subform loads before the main form - yes, sounds weird but that's the way it is.

So if dynamic parameter query is the subform RecordSource and the input controls are on main form, the controls are not available for reference, and therefore the popups.

If the inputs are in the subform (Continuous View?) then referencing the controls by the query is more complex. Post the query SQL statement.

Why form/subform arrangement? Is the main form bound to data?

[orange]

Fay,

Suggest you tell us WHAT you are trying to accomplish in plain English. Then readers can offer suggestions/options.

[faythe1215]

That tutorial does not involve form/subform arrangement.

Be aware that subform loads before the main form - yes, sounds weird but that's the way it is.

So if dynamic parameter query is the subform RecordSource and the input controls are on main form, the controls are not available for reference, and therefore the popups.

If the inputs are in the subform (Continuous View?) then referencing the controls by the query is more complex. Post the query SQL statement.

Why form/subform arrangement? Is the main form bound to data?

My search form is actually a simple form (to be used as a subform) with two fields. One for the Recipe Name and one for the Ingredients. I have the values defaulted as "".

My SQL statement looks like this in both fields with the respective field name changed:
Like "*" & [Forms]![frmRecipeEditSearch]![txtRecipeName] & "*"

Fay,

Suggest you tell us WHAT you are trying to accomplish in plain English. Then readers can offer suggestions/options.

Sorry, I didn't realize that my original post was convoluted. I'll try again

The whole of what I am trying to do:

This is actually part of my Main Switchboard which I currently have tabbed. On the Recipes tab, I have a series of buttons that allow the user to

• Add A New Recipe
  When clicked, this button opens a new form that allows the user to add a recipe (I'm pretty sure I've got this one finished)
• Edit An Existing Recipe
  When clicked, this button displays the subform frmRecipeEditSearch which has two fields (txtRecipeName and txtIngredient), a button that resets the fields (sets them to "") and a button that runs a query and them displays those results in a form.
  

      DoCmd.OpenQuery "qryRecipeLink_Complete_Search"
      DoCmd.OpenForm "frmRecipeSearchResults"

  When the user selects an item from the form, a new form will open that will allow them to edit the recipe.
• Search for A Recipe
  This one will run similarly to the above button but when they click on an item from the result form it, the recipe will display as a report rather than as a form. (I haven't even started on this yet)
• Display a Complete List of All the Recipes
  When clicked, this report of all the recipes stored by type (I'm pretty sure I got this one too, but I still have to test it a bit)

This project is much bigger than even this, but this is where I am right now. I hope this was more clear.