How to open a query in a form

[Need_Help]

Hi all,



I have a form that involves a number of text boxes that users may enter text into. Then a button allows them to search by certain fields and the query displays the results in a table format. However, my database involves embedded images and I want users to be able to view them after submitting the query. How can I direct my query to display the results in another form?

Thanks a lot in advance

[June7]

One way is to set up the second form's RecordSource to refer to the controls of the first form in the Criteria row.

[Need_Help]

OK thanks, that seemed like the first step. I changed the Record Source so that it references a query; I cannot get it to reference another form. The 2nd form will display the results of the query based on what was entered into the corresponding text boxes, but will only appear if you manually open it. I would like for it to come up automatically.

[June7]

Don't understand, your statements 'cannot get it to reference another form' and '2nd form will display the results of the query based on what was entered into the corresponding text boxes' appear contradictory.

Need code to open the 2nd form. Use a command button Click event.
DoCmd.OpenForm "formname"

[Need_Help]

Thanks! That piece of code worked, combined with adding the query to the form's record source. Excellent.

What my statements earlier had meant that the main form wasn't opening the display form. By opening the display form, I could view the results of a query because the query itself included the entries from the main form. But I would have to keep switching between forms, something I don't want my users to be doing.

Now one last question that could save some work or at least my navigation pane from getting too cluttered. Can I make this 2nd form open up the results of any query, where the buttons on the main form decide what query is getting used? Or do I have to create a form for each query?

[June7]

What is different about these other queries? Different table source with different fields then yes need a different form. Or are these queries all identical except for filter criteria? Then one form bound to unfiltered query. Send filter criteria to the form.