Results 1 to 5 of 5
  1. #1
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408

    filter a form with multi values in another form

    hi
    i'd like to filter a contiuos form using another form (a continuos one too) in which i put many values as filters.
    maybe with the possibility to choose the logical operator (LIKE, "=",NOT LIKE etc)

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    So you are creating records in a table with values to be used as criteria to filter a form?

    For a conventional search form review http://allenbrowne.com/ser-62.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    looks like the stuff i was looking for! i'll make you know

    Edit that's not what I'm looking for... I have already a form like this
    The problem is that for every field I'd like to set many criteria, e. G. "city name is" and "not like"

  4. #4
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    i found the solution using a table and a form as filter, with a recordset
    this is the file if someone is interested.
    sorry, it's in italian

    ps i ended my trial of winzip and i didn't buy it
    https://drive.google.com/file/d/1nv2...ew?usp=sharing

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Use Windows Compression to zip files.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Utilizing Multi values in a form format
    By gilinnc in forum Forms
    Replies: 6
    Last Post: 02-28-2018, 01:56 PM
  2. Replies: 5
    Last Post: 03-16-2015, 09:36 AM
  3. Replies: 2
    Last Post: 01-30-2014, 12:10 PM
  4. Filter and Sort a form based on TextBox Values.
    By Ramun_Flame in forum Programming
    Replies: 7
    Last Post: 10-28-2012, 06:53 AM
  5. Replies: 1
    Last Post: 04-27-2010, 09:30 PM

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