Report Filter

[DragonTech]

I'm trying to use a command button in a form to filter and open a report. I am able to get it to open the report, but I cannot get it to filter the report based on a combobox in the form. I've tried every combination of code I could think of and find. Here is what I currently have:

Private Sub FilterReport_Click()
DoCmd.OpenReport "Report", acViewReport, "First Name='" & Me.FName & "'"
End Sub

Option Compare Database

Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = Me.FName
End Sub

"FilterReport" = Form Button
"Report" = Report


"First Name" = Report Field
"FName" = Form Combo Box

[RuralGuy]

Field names with embedded spaces need brackets.
"[First Name] ='" & Me.FName & "'"