Filter on selected ? (1 Viewer)

[ECEK]

I am trying to filter my data based upon the content of the data within the field that I wish to filter.

I'm getting rather lost.

Could you help me please?

This is what I have tried on click

DoCmd.ApplyFilter , "SalesPerson = Me.Salesperson"
DoCmd.RunCommand acCmdRecordsGoToLast

Thanks for your time in advance.

 

[isladogs]

You need text delimiters

DoCmd.ApplyFilter, "SalesPerson = '" & Me.Salesperson & "'"
DoCmd.RunCommand acCmdRecordsGoToLast

 

[ECEK]

Many thanks isladogs.