Opening Report Associated with Particular Number on Form

[pclutts]

The Record Source for the form called frmConstructionProjects is the query called qryConstructionProjects. On the form, there is a command button called "Go To DBE Form". The On Click Event Procedure for the command button opens the form frmDBE. The form opens to the same record associated with the text field called "CSJ Number", which is on both forms. On the form frmDBE, there is also a command button called "Print/Preview DE Report". The On Click Event Procedure for this command button opens the report called "rptDBEKatyRpt". When the report is opened, it shows information on all 5 CSJ Number records. However, I want the report to show information only associated with the CSJ Number shown on the form frmDBE prior to clicking the command button "Print/Preview DBE Report". It's probably something very simple, but I can't figure it out. I can send a sample database via email for anyone's review. Any help would be greatly appreciated. Thanks in advance.

 

[ColinEssex]

In the query behind the report you need the criteria to pick up the CSJ Number that is shown on the form.

So in the criteria line of the CSJ Number field put

=Forms!frmDBE!CSJNumber

then you'll only get the one thats on the form.

Col

 

[pclutts]

In the query behind the report you need the criteria to pick up the CSJ Number that is shown on the form.

So in the criteria line of the CSJ Number field put

=Forms!frmDBE!CSJNumber

then you'll only get the one thats on the form.

Col

Thanks for the help. It worked.