docmd.apply filter - to exclude matched records

[matt beamish]

Hello people,
have spent a few hours on this today, and I am not getting anywhere.
I want to apply a filter in VBA to exclude records based on a value.

So what is the negative of this

 DoCmd.ApplyFilter , "[FirstName] = 'Anonymous'"

Help please, I am getting a bit frayed!

thanks
:banghead:

 

[Frothingslosh]

DoCmd.ApplyFilter , "[FirstName] <> 'Anonymous'"

 

[matt beamish]

Thanks for speedy reply.
M