Access VBA Filter Syntax

[tylerg11]

I am trying to use Access VBA to apply a simple string Filter to my Form. My code includes the following syntax:

CONTACT_LASTNAME like '%" & strLastName & "%'"

I am looking to execute a Contains filter. Is the proper syntax? Sometimes it seems to work, but it is not consistent in which records it is filtering.

[pbaldy]

Try * instead of %.

[tylerg11]

Now I get no results..

[pbaldy]

Curious, as in the form filter I'd expect *; % is used in ADO. Can you post a sample db that exhibits the inconsistent behavior?