How to add a filter in Acess in VB

[danijela.simunovic]

How do I add a filter in VB?
is this enough: DoCmd.ApplyFilter , "LastName = 'King'" or I
need something before this which would say in which table or query?
And how do i close the filter,how do i remove it?

Danijela

[Salad]

da****************@gmail.com wrote:

How do I add a filter in VB?
is this enough: DoCmd.ApplyFilter , "LastName = 'King'" or I
need something before this which would say in which table or query?
And how do i close the filter,how do i remove it?

Danijela

For a form, I like Filter And FilterOn
Sub SetFilter(strFilter As String)
Me.Filter = strFilter
Me.FilterOn = (strFilter > "")
End Sub

You could pass this to set a filter to display records with ID = 123
SetFilter "ID = 123"

And to clear a filter
SetFilter ""