Results 1 to 3 of 3
  1. #1
    eww is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    125

    Multiple filtering options in vba

    I'm trying to add a command to open a report with multiple filtering conditions.

    This is my code so far, it opens the report and filters it to a single person based on who the user is:



    DoCmd.OpenReport "rptToDoList", acViewReport, , "Detailer = '" & Me.txtUser & "'", acWindowNormal

    I also need to filter one of the other categories (ActualSubmittalDate = Blank) but I don't know the syntax for having multiple where conditions in vba.

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    DoCmd.OpenReport "rptToDoList", acViewReport, , "Detailer = '" & Me.txtUser & "' and actualsubmittaldate is null ", acWindowNormal

  3. #3
    eww is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    125
    Sweet! Thank you. I knew it was something like that, but couldn't get it in the right place.

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

Similar Threads

  1. Access Options Button
    By 95DSM in forum Programming
    Replies: 1
    Last Post: 08-16-2010, 03:05 PM
  2. Multiple options to create semi-unique letters
    By GenericHbomb in forum Import/Export Data
    Replies: 0
    Last Post: 07-27-2010, 08:46 AM
  3. Grouping Options
    By Desstro in forum Queries
    Replies: 1
    Last Post: 06-20-2010, 06:33 PM
  4. Restrict Combo Box Options
    By KWarzala in forum Forms
    Replies: 1
    Last Post: 03-03-2010, 04:46 PM
  5. Toggle Button Options
    By Matthieu in forum Forms
    Replies: 2
    Last Post: 11-23-2009, 04:05 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