report requires user input

[ColinSully]

I have inherited an access 97 database and I am looking to modify it. I do not have a lot of experience with Access however.

One of the reports that is being generated requires a user to input a project ID (a pop up box is displayed when you click on the report) to specify which projects data to pull from a table to populate the report.
I would like to modify this to show a list of the projects available and teh user can select one.

I do not know how this pop up box is being generated and I looked in both the code and design of the report.

If anyone has any ideas on where I could go to change this pop up box it owuld be greatly appreciated.

Many thanks,
Colin

 

[drock99a]

The pop up box is most likely coming from your query. look for something like this in one of your queries:

[Project Id:]


You can create a new form with combo box to display your project ID's and then place the following in your query in your Project ID field.

[Forms]![Form1]![Combo1]

 

[Norie]

It will probably be a parameter in the query the report is based on.

Go to design view and look at the RecordSource property of the report.

To do what you want you would have to create a form that had a combobox with the Project IDs and a command button.

User then picks which project they want, clicks the command button which then opens the report.

To do this you'll need to change the parameter in the query to something like [Forms]![NewForm]![ProjectID].

I think there are examples in the Northwind DB.

 

[ColinSully]

I have found in my querie the following 2 columns:
Field: [Please enter the project’s ID]
Table:
Total: Where
Sort:
Show: (unchecked)
Criteria: [Record].[ProjectID]

Field: ProjectID
Table: Project
Total: Where
Sort:
Show: (unchecked)
Criteria:[Record].[ProjectID]

I have also created the combobox to display the ID's.

I am now wondering where exactly I put the: [Forms]![Form1]![Combo1]

I hope you can help,
Colin

 

[drock99a]

in the project id field in the query.

 

[ColinSully]

Sorry, I still don't get this. What do I replce with the [Forms]![Form1]![Combo1].

I have tried it a number of ways and can't get it to come up.

 

[bat17]

First have you renamed [Forms]![Form1]![Combo1] to match the real name of your Form/Control.

It goes in the criteria row of the query below the field that you are filtering by.

HTH

Peter

 

[ColinSully]

This is what I now have:

Field: [Please enter the project’s ID]
Table:
Total: Where
Sort:
Show: (unchecked)
Criteria: [Record].[ProjectID]

Field: ProjectID
Table: Project
Total: Where
Sort:
Show: (unchecked)
Criteria: [Forms]![Form1]![Combo0]

The form/control are correctly named but I am still just getting a text box to "Enter Parameter Value" into when I try to open it.

 

[bat17]

Try deleting out the column
Field: [Please enter the project’s ID]
Table:
Total: Where
Sort:
Show: (unchecked)
Criteria: [Record].[ProjectID]

Peter

 

[ColinSully]

Still nothing. I am now just getting the "Enter Parameter Value" box with "Forms!Form1!Combo1" as the label