Filter Report by Field in Form

[SpdRacerX]

I tried to search for this but I'm just not getting it.



I want to filter a report depending on a field in a form. The field is text.

Here's the simplest way I found, but it returned NO values in the report. Am I missing anything?

Private Sub cmdViewReferral_Click()
DoCmd.OpenReport "Referral Report", acViewPreview, , "[Assigned To] = '" & Me.[Employee Name] & "'"
 
End Sub

[Assigned To] is the Field in the Report (which is grouped by)
[Employee Name] is the Field in the Form

[June7]

The syntax looks correct.

You say [Assigned To] field is text? So it actually holds the employee name and not an employee ID?

Is [Employee Name] also name of a combobox on form?

[SpdRacerX]

[Assigned To] is a combobox in a table
[Employee Name] is a concatenate expression in a query

[June7]

A combobox in table? You mean you have a Lookup set in table? Lookup does not change the value in the field. You see an alias value but the actual value is still what is in the field. So when you refer to that field you are retrieving the actual data, not the alias.

I NEVER set Lookups in table. As developer, I want to see the real values when I view tables.