Results 1 to 4 of 4
  1. #1
    As226 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Posts
    9

    Multicriteria search


    hello the forum I'm asking for your help.
    I would like to perform a multicriteria search to display the results in each field and be able to modify them directly from the form.
    I ask your help for the code to use.

    - The 3 criteria to be gathered are indicated in the boxes "" criter1 "", "" criter2 "" and "criter3".
    - The boxes to fill in are '' box1 '', '' box5 '' and '' box6 ''
    - the name of the table is '' source ''
    - the fields of the table in the order: '' id # '', '' criter1 '', '' critere2 '', '' criter3 '', '' box1 '', '' box5 '' and '' 'box6' '.
    Help me please
    Thank you in advance

    https://www.cjoint.com/c/ICEwffuHQ7l

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    What exactly are you searching for? An example of your proposed search would be helpful.
    Look at the Similar Threads at the bottom of this thread for ideas.
    Most often referenced site for search is this by Allen Browne.

  3. #3
    As226 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Posts
    9
    Thank for your answer orange.
    For example
    If a chose ''A'' as criter1, ''A'' as criter2 and ''B'' as criter 3 i woul like to have in the box 1 the result of the field responding to the 3 criterias.

  4. #4
    As226 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2019
    Posts
    9
    Thanks for the link, the result on this example is a row but i would like to have the result in a box

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: 8
    Last Post: 09-02-2015, 03:00 PM
  3. Replies: 1
    Last Post: 03-26-2015, 11:08 AM
  4. Replies: 3
    Last Post: 01-04-2015, 06:09 PM
  5. Replies: 3
    Last Post: 09-02-2013, 04:33 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