Alternatives to Enter Parameter Value pop up box? ---------

[Mark909]

Ive got a form set up as a Main Menu for a number of queries on the data held
by my company.

Im new to Access and have set up the Buttons so that when they are clicked
it will create a report based on a query.

At the moment I have the queries set up so the Enter Value pop up box
appears when the query is run when you type in a project ID

i.e. [Enter PROJECT_ID]

I was wondering if there might be any alternatives to doing this to get the
query to run to create a report?

Something like a dropdown box when I can select a choice of Project_IDs. You
could then run the query and create the report on the selected Project_ID

 

[RonaldoOneNil]

Once you have created your combo box (called cmbProjectID in my example) on
your main form, you can put this in the criteria of your Project ID field in
your query
[Forms]![Main Menu]![cmbProjectID]

 

[Mark909]

Thanks.

However I cant get it to work.

Could you break the process down for me a bit more cos im quite new to Access

is [Main Menu] the name of the Form where the combo box is located?

Once you have created your combo box (called cmbProjectID in my example) on
your main form, you can put this in the criteria of your Project ID field in
your query
[Forms]![Main Menu]![cmbProjectID]

Ive got a form set up as a Main Menu for a number of queries on the data held
by my company.

Im new to Access and have set up the Buttons so that when they are clicked
it will create a report based on a query.

At the moment I have the queries set up so the Enter Value pop up box
appears when the query is run when you type in a project ID

i.e. [Enter PROJECT_ID]

I was wondering if there might be any alternatives to doing this to get the
query to run to create a report?

Something like a dropdown box when I can select a choice of Project_IDs. You
could then run the query and create the report on the selected Project_ID

 

[RonaldoOneNil]

Yes, and cmbProjectID is the name of the combo box control on this form that
contains your list of Project ID's.

Thanks.

However I cant get it to work.

Could you break the process down for me a bit more cos im quite new to Access

is [Main Menu] the name of the Form where the combo box is located?

Once you have created your combo box (called cmbProjectID in my example) on
your main form, you can put this in the criteria of your Project ID field in
your query
[Forms]![Main Menu]![cmbProjectID]

Ive got a form set up as a Main Menu for a number of queries on the data held
by my company.

Im new to Access and have set up the Buttons so that when they are clicked
it will create a report based on a query.

At the moment I have the queries set up so the Enter Value pop up box
appears when the query is run when you type in a project ID

i.e. [Enter PROJECT_ID]

I was wondering if there might be any alternatives to doing this to get the
query to run to create a report?

Something like a dropdown box when I can select a choice of Project_IDs. You
could then run the query and create the report on the selected Project_ID