Reports filtering problem 1

[jpl458]

I have a form that is open (fmCust_Hist) and I want to print a report of the data in that form. I have created a print button on the form that prints a report (CustHistReport). The control source for the report is a query (Cust_History). I want to filter the data for that report with the data that is in Account_Number which is a text box on the form. In the filter field on the report form I have the following:

[Account_Number]='forms!fmCust_History.Account_Number'.

However, the report displays the entire file, and is not constrained. Obviously I am doing something wrong.

The [Account_Number] is the field in the report, and fmCust_History.Account_Number contains the value I want to filter on.

Hope I have this clear enough.

Thanks

jpl

 

[PWise]

try
[Account_Number]=forms!fmCust_History.Account_Number
not
[Account_Number]='forms!fmCust_History.Account_Number'

 

[dhookom]

I would expect to see code like:

Dim strReport as String
Dim strWhere as String
strReport = "CustHistReport"
If not IsNull(Me.Account_Number) Then
  strWhere = "Account_Number = """ & Me.Account_Number & """"
End If
DoCmd.OpenReport strReport, acPreview, , strWhere

Duane
Hook'D on Access
MS Access MVP