print report based on query

[JohnHo]

why won't this work?

I have a form which has a text box: forms!frmCaseLog!tboCaseID the RecordSource for the form is tblCaseLog with the field [lngCaseID]

I would like to print a report with details entered into the form.

For the report RecordSource I have created a query "qryCurrentCaseInfo" which has in the criteria for [lngCaseID] the control above on the form "frmCaseLog"

I have a command button [cmdPrint] to print the report with the code

Private Sub cmdPrint_Click()
 
Dim stDocName As String
 
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 
 
With Forms!frmUrgentTriage1 
 
    .tbo2CaseID.SetFocus 
    .tbo2CaseID.Requery 
    .Repaint 
 
End With
 
 
 
    stDocName = "Report1"
    DoCmd.OpenReport stDocName, acNormal
 
End Sub
 
 

If I debug.print the control I get the Case ID value but I cannot get the query to use the Case ID value as the criterion for the report.

what gives? am I missing something?

thanks a bunch!

/jh

[Stewart Ross]

It would help us to give some kind of answer if you would kindly post the SQL statement which refers to that control. It is otherwise impossible to hazard a guess at what might be happening without something more specific to work on.

I am assuming that the SQL statement will be part of the recordsource for Report1.

Anyway, it is usually easier not to make the recordsource SQL dependent on the form, but instead to filter the report when it is opened (using the Where part of the DoCmd.OpenReport statement).

-Stewart