Results 1 to 4 of 4
  1. #1
    fluffyxtera is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    1

    Combo Box Criteria Range


    I have a report that opens from a form. This form has two combo boxes "cboVenOne" and "cboVenTwo" and a button that says run report. I want the query to pull up the ranges of vendors between those two combo box selections. I am assuming I would use a CoCmd.OpenReport with a where command. Any help would be appreciated.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    in your vendor name criteria put

    [VendorName] between forms!formname!cbovenone and forms!formname!cobventwo

    Assuming this is an alpha vendor name description

    If you want a query that will run if the vendors are left blank or if only a single vendor is present you can also do that with formulas

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    been an extremely busy 6 months or so and all of a sudden I had a slow day!

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

Similar Threads

  1. sumif for same field range & criteria
    By sunitarobert in forum Queries
    Replies: 4
    Last Post: 12-07-2015, 03:20 AM
  2. Replies: 3
    Last Post: 04-20-2014, 08:39 AM
  3. Forms and Date Range Criteria
    By RoundTrip in forum Access
    Replies: 9
    Last Post: 02-12-2014, 10:02 PM
  4. Date Range Criteria help
    By jsubby3 in forum Access
    Replies: 7
    Last Post: 12-03-2012, 03:14 PM
  5. Criteria to show date range
    By Douglasrac in forum Queries
    Replies: 2
    Last Post: 03-24-2011, 03:58 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