Run a query based on an input from a form

[apoorv]

I have a form called year. the end user shall type in the year value in the same.

1. based on the year value, i want the query "cost_hist_db" to run for the same year. i am not able to do the same.
2. is it possible to run multiple queries by the click of a single button? if yes then how?
3. is it possible to automate the run of a query based on the results of another query? if yes how?

[khalid]

you need to create another query to get the crosstab query data based on your form (year criteria)

UPDATES:-

Your db is attached herewith: The db is converted to M-access 2010 windows 7.

A temp table (corsheet1) is created to get the year value on the form. On click event of the form button, two queries run simultaneously:

Private Sub Command2_Click()
DoCmd.OpenQuery "crossSheet1"
DoCmd.OpenQuery "Cost_Hist_DB"
End Sub

crossSheet1 is used to populate the corsheet1 (table) and Cost_Hist_DB is your crosstab query respectively.

Hope this solve your problem!

[apoorv]

based on the year value, i want the query "cost_hist_db" to run for the same year. i am not able to do the same.

This is my critical issue

[apoorv]

Thanks a lot sir. you have been great.

[khalid]

Glad that your problem has been sorted out. Please mark this thread as solved by clicking thread tools top of this thread.