open a form based on text in first form

[jojo]

I have a an unbound form with 3 text boxes which I created as a modal dialog form, and I'm pretty sure that's waht I need. The user will enter text into 3 text boxes (and one of them should really be a combo box) and the main form based on the data table should open displaying only the records that match those 3 criteria. I have it almost working, BUTwhen I enter data into the calling form, and click OK, I get a box asking for the values using the search forms' names. I enter the criteria again, the form does open showing the right records. I am sure I missing somethng simple. I assume the form to do this is modal dialog, as it seems to describe what is needed. Access 2010.
Thank you very much
JoJo

 

[mahenkj2]

I think you are using a query in which criteria is set referencing fields from your first modal dialog box. It may have something to do with parameters set, though not sure.

I design view, you can see parameters in A2007.

Else, post a sample dB.

 

[jojo]

Thank you, mahenkj2, for your quick reply. Yes, my form with the 3 text boxes to collect the user's input is in lieu of a parameter with 3 separate boxes popping up to accept user input. I have the 3 boxes on one form and the user will enter a name, a state and a zip. Then the form based on the table with all the data should open up showing only the record(s) that match the user's input. What is happening now, is after filling in the fields in the form, a parameter query comes up asking for the info again, which is what happens when a form has a misspelled data name. I hope this makes a little sense...
Thank you for any help
JoJo

 

[mahenkj2]

OK.

So, I think you may have criteria at two places. One at in criteria condition of a query and second at Parameters section of query. Have you checked. Else, you have mis-spelt the parameters, so although you fill the first form, you have to again input the data.

If you are able to find the difference, its ok,else post your sample dB after removing any critical data.

regards.