Results 1 to 2 of 2
  1. #1
    aligahk06 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    19

    Search in a form

    Dear All,

    I added a search command button in my form and then build to Apply filter where condition


    Tenent's Name LIKE * "" & [forms]![TenentListEntryForm]&""

    I want to search by Tenent's name, Please rectify the above where condition
    Tenent's Name - Table field
    [TenentListEntryForm] - Forms name


    Please assist..

    Rgds,
    aligahk06

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,124
    perhaps

    "Tenent's Name LIKE '*" & [forms]![TenentListEntryForm] & "*'"

    If not, show the block of code where you have attempted this because it's not clear if you already have leading and trailing quotes done correctly.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-12-2016, 11:49 AM
  2. Replies: 10
    Last Post: 09-08-2016, 08:09 PM
  3. Replies: 8
    Last Post: 09-02-2015, 03:00 PM
  4. Replies: 3
    Last Post: 09-02-2013, 04:33 PM
  5. Replies: 1
    Last Post: 04-20-2012, 03:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums