Report Record Selection 1

[Grumm]

Hi, I have a form which is used to record and calculate project costs for each project. These tables hold information on many projects. At the bottom of the form I have a commant button that runs a report. The ptonlem I have is the report shows all projects but I only want the project on the form to be printed.

I am sure I am doing somthing silly.

 

[KenReay]

Hi

Assuming unique id of Project is held in a control on the form called ProjectId, then in the DoCmd which invokes the report put:

DoCmd.OpenReport stDocName, acPreview,,"ProjectId = '" & Me.ProjectId & "'"

Assuming ProjectId is a string, if it is a numeric, then you can drop the '

Note if the form is also used to update the Project details, it would be wise to check if the form has been updated, and save the information before calling the report, eg

If Me.Dirty then
docmd.runcommand accmdsaverecord
End If Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK