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

 

[Norie]

is the form actually open when you get this?

 

[bat17]

Can you go into SQL view in the query and post the SQL here please

Peter

 

[ColinSully]

Here it is. I did not make this code and am not quite sure how to read it.

SELECT Record.ProjectID AS RequestedID, Project.ProjectName, Project.ProjectDescription, Project.ProjectAccount, FROM Record, Project

GROUP BY Record.ProjectID, Project.ProjectName, Project.ProjectDescription, Project.ProjectAccount

HAVING (((Record.ProjectID)=[Forms]![Test]![ProjectID]));

 

[bat17]

Apart from a stray comma after Project.ProjectAccount it looks OK try,

SELECT Record.ProjectID AS RequestedID, Project.ProjectName, Project.ProjectDescription, Project.ProjectAccount
FROM Record, Project 

GROUP BY Record.ProjectID, Project.ProjectName, Project.ProjectDescription, Project.ProjectAccount 

HAVING (((Record.ProjectID)=[Forms]![Test]![ProjectID]));

Having a table called 'Record' may upset Access if it is a reserved word.
Peter