Filter On Open of a form

[sdimaggio]

I want to filter a query which is the record source of a form when it opens. I want to filter the data based on sales rep so the salesman can only see their data when the form comes up. here is my code. it does not work.

Private Sub Form_Open(Cancel As Integer)

Me.AllowFilters = True
Me.Filter = (([qry_Approval Profile].[Sales Rep]="Bob&quot)

End Sub

Any help would be welcomed.

Thanks,

Steve

 

[gol4]

Sub Form_Open(Cancel As Integer)

Me.AllowFilters = True
Me.Filter = (([qry_Approval Profile].[Sales Rep]="Bob&quot)
docmd.applyfilter
End Sub

 

[sdimaggio]

Thanks