Using queries with form

[Frodo]

I have a form where I want the user to be able to select different options and get appropriate results according to the selectin.

Now I have already created the query I am just wondering how to I connect the Form to the query so that when the user selects what he wants to see and the query will pop up.

Or is my idea wrong on how to use form to see results from a query ?

regards
Frodo

 

[Michael J Ross]

Set the Record Source for the form to the name of the query.

In the query reference the criteria to the appropriate text/combo boxes on the form using [Forms]![nameofyourform]![nameofyourfield]

 

[Frodo]

Set the Record Source for the form to the name of the query.

When I do that and than i switch to or right click the form window and select Form View I cant see anything on the form all the buttons and combo boxes are not showing.

When I switch back to "Form Design" everything is there but back to "Form View" all the buttons and combo boxes dissapear cant see anything... ????

 

[Michael J Ross]

Do you have the Form set to Data Entry: Yes, if so change to No