Solved Why is my Filter not working? (1 Viewer)

[cheberdy]

I want to find a record in a form. To do this, you enter a number and press a button. I have this filter code, but it does not seem to work. I already debugged it and the values are correct

Private Sub Befehl18_Click()
Dim number As String


number = Textfield1.Value
If Not IsNull(number) Then
Me.Filter = number
Me.Filter = True


End If


End Sub

 

[CJ_London]

Your filter needs to be something like

“somefield =“ & number

 

[ebs17]

1) Filtering means hiding everything that does not meet the filter condition, i.e. where the application of the filter condition results in False.

Me.Filter = True

With ALL True, there can be no data reduction.
@CJ_London shows you the right direction.

2) You don't just have to define a filter, you also have to actively use it.

Me.FilterOn = True

 

[Gasman]

I want to find a record in a form. To do this, you enter a number and press a button. I have this filter code, but it does not seem to work. I already debugged it and the values are correct

Private Sub Befehl18_Click()
Dim number As String


number = Textfield1.Value
If Not IsNull(number) Then
Me.Filter = number
Me.Filter = True


End If


End Sub

How is Access meant to know which field to search for that value?
Have you even looked up how to use a filter?

Form.Filter property (Access)

Office VBA reference topic

learn.microsoft.com

 

[arnelgp]

I want to find a record in a form. To do this, you enter a number and press a button. I have this filter code, but it does not seem to work. I already debugged it and the values are correct

i also suggest reading a good material about MS Access.
it's hard programming blindly.

 

[Gasman]

i also suggest reading a good material about MS Access.
it's hard programming blindly.

Well there is always Google?
Either way you would still have to search, be it book or search engine.