Results 1 to 6 of 6
  1. 07-09-2017, 12:19 PM #1
    gheyman
    gheyman is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    22

    Query Criteria based on Multi Selection of a List Box?

    Can a Query Criteria based on Multi Selection of a List Box?



    Form = frmCustomerRecord
    My List Box = "ListCustomer"
    Reply With Quote Reply With Quote
  2. 07-09-2017, 12:42 PM #2
    orange's Avatar
    orange
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    You will need some vba to deal with the listbox.
    Here is a link to Allen Browne article
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
  3. 07-09-2017, 01:28 PM #3
    gheyman
    gheyman is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    22
    Thank You, Orange!
    Reply With Quote Reply With Quote
  4. 07-10-2017, 05:55 PM #4
    Micron
    Micron is online now Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,422
    Another cross posting by this member
    https://www.mrexcel.com/forum/micros...ml#post4864702
    Reply With Quote Reply With Quote
  5. 07-11-2017, 04:17 AM #5
    gheyman
    gheyman is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    22

    Question ?

    Quote Originally Posted by Micron View Post
    Another cross posting by this member
    https://www.mrexcel.com/forum/micros...ml#post4864702
    What? Is this a problem? Is it wrong to see multiple suggestions to solve a problem?
    Reply With Quote Reply With Quote
  6. 07-11-2017, 04:29 AM #6
    gheyman
    gheyman is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    22
    Thanks, I didnt know using more than one forum for suggestions/answers was wrong. Just trying to learn and thought many teachers with various views was a good way. Most times there are more than one way to tackle a problem. Will curtail double posting without letting it be known. I almost always Thank the responder which I understand closes the posting so no one continues to work it. My apologies to all
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Multi list box selection to run query
    By aellistechsupport in forum Forms
    Replies: 15
    Last Post: 11-02-2015, 09:21 PM
  2. Query criteria based on multi select list box?
    By Sailor in forum Forms
    Replies: 3
    Last Post: 04-08-2014, 01:02 PM
  3. Two Multi Selection List Boxes to Query Results
    By Breezer23 in forum Forms
    Replies: 3
    Last Post: 03-14-2014, 02:19 PM
  4. Multi Select List Box selecting Query Criteria, Criteria come up with quotation marks
    By very_much_a_beginner in forum Queries
    Replies: 5
    Last Post: 08-02-2012, 09:44 AM
  5. Crosstab Query based on Multi-List form selection
    By jtish in forum Queries
    Replies: 2
    Last Post: 06-09-2012, 07:59 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums