Results 1 to 2 of 2
  1. 01-25-2011, 03:42 PM #1
    jlclark4
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155

    using unbound combo box to filter report

    I am trying to filter a report based on the name selected in a drop down combo box. How can I get this done? I tried adjusting the VB for the command button but since they do not have matching fields (since the combo box is unbound) it didn't work...
    Reply With Quote Reply With Quote
  2. 01-25-2011, 04:12 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    This should work:

    BaldyWeb wherecondition

    The wherecondition argument works the same for OpenReport.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Apply Filter based on unbound date boxes
    By anoob in forum Access
    Replies: 3
    Last Post: 01-21-2011, 05:26 PM
  2. Using Dlookup in unbound text box in report
    By PrintShopSup in forum Reports
    Replies: 3
    Last Post: 12-27-2010, 10:29 AM
  3. Capture 2nd Value in an unbound Combo.
    By sesproul in forum Forms
    Replies: 5
    Last Post: 04-30-2010, 02:07 PM
  4. requery unbound combo box from called form
    By Mansi in forum Forms
    Replies: 1
    Last Post: 03-26-2010, 10:32 PM
  5. Combo Box Filter
    By jgelpi in forum Programming
    Replies: 3
    Last Post: 07-27-2009, 12:54 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums