Creating Form that Calls on Query

[dbalilti]

Hey guys,



So I am trying to create a form that will call a query of mine up.

The catch is , the query requires me to input a range and then it filters the databse that way.

So i want to make a form that allows me to insert the range then press a button and opens up the query in a subforum.

Can anyone lead me in the right direction??

thankyou

[John_G]

Hi -

The easiest way is use a form to input the query criteria, then in include the criteria in a docmd.openform statement, for example:

DoCmd.OpenForm "frmCustomer_Orders", , , "Customer_ID = " & Me!customerID

The bold text is just like a WHERE clause but without the WHERE.

How do want to use the query data that will be in the form? It is just for viewing, and does it require a response of some sort? If so, you may want to make the query result form MODAL so that you cannot continue until you close it, but that depends on what you need to do.

What I have shown you is not for a subform - you can still do what you want with a subform, but in a different way.

HTH

John