opening report limited by a field

[ejmiller2]

i am trying to open a report that is limited by the SSN field of the table PeopleNotEmailed. When typing in the following i get a pop up box that asks me for [PeopleNotEmailed].[SSN]. I know i spelled it right and that there are numbers in there. If i instead plug in a number for [PeopleNotEmailed].[SSN] it works. any suggustions?...

DoCmd.OpenReport "Payroll", acPreview, , WhereCondition:="[PeopleNotEmailed].[SSN] = [SSN]"
thanks
eric

 

[jfgambit]

DoCmd.OpenReport "Payroll", acViewPreview, , "[SSN] = '" & Me.SSN & "'"

HTH


"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[PaulF]

one method is to create a query for the report and have the criteria based on the Form's value
Example Control on the Form (frmPayRoll) that will have the value is txtReportFilter, the query would be

Select * From TableName Where SSN = Forms!frmPayRoll.txtReportFilter Or Forms!frmPayRoll.txtReportFilter Is Null


The "Or Forms!frmPayRoll.txtReportFilter Is Null" part allows the report to be used to print all records or only the one selected by the TextBox. Just have to keep the Form Open to use the Filter condition.

PaulF