VB-Access Filter in Form

[juanchodavid]

Hi,
I'm having this problem, seems no big deal but I just don't find the way to solve it: I have a field in a form where the user writes a filter criteria and then accepts by pressing a button. The filter works good until the user uses the ' * ' in the search field. In that case no data is shown. The simplest example is when the only filter criteria is *. All the data should be shown, but by this filter method no data at all is shown.

The part of the code is:

Form.filter="Segment " & = '" & Field.Value & "'"
Form.FilterOn = True

Any ideas?
Thanks!

[puppydogbuddy]

Hi,
I'm having this problem, seems no big deal but I just don't find the way to solve it: I have a field in a form where the user writes a filter criteria and then accepts by pressing a button. The filter works good until the user uses the ' * ' in the search field. In that case no data is shown. The simplest example is when the only filter criteria is *. All the data should be shown, but by this filter method no data at all is shown.

The part of the code is:
Form.filter="Se gment " & = '" & Field.Value & "'"
Form.FilterOn = True

Any ideas?
Thanks!

Try changing your syntax for the filter as follows:

Form.filter="Se gment = '" & Field.Value & "'"

[NeoPa]

Try the following :

Me.Filter = "[Segment] Like '" & Field.Value & "'"
Me.FilterOn = True

This allows the operator to specify whether he wants to use pattern matching or only an exact match.

[juanchodavid]

Try the following :

Me.Filter = "[Segment] Like '" & Field.Value & "'"
Me.FilterOn = True

This allows the operator to specify whether he wants to use pattern matching or only an exact match.

Thanks a lot! it solved the problem

[NeoPa]

No problem - Pleased it helped :)