LIke Statement

Posted on 2011-10-19
Last Modified: 2012-05-12

I need a like statement in the below but not sure how to do this.
="[EndUserID]=" & [txtEndUserID]

I have tried
="[EndUserID]=" * & [txtEndUserID] & *
but that is not it

Please see below.  
It is in a macro.
 Like Statement
Question by:pdvsa
    LVL 119

    Accepted Solution


    "[EndUserID] Like '*" & [txtEndUserID] & "*'"


    "[EndUserID] Like "*" & [txtEndUserID] & "*""
    LVL 119

    Expert Comment

    by:Rey Obrero
    you may need to change this



    Author Closing Comment

    than you sir..

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now