Results 1 to 2 of 2
  1. #1
    Dick38 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Sep 2016
    Location
    East Gippsland
    Posts
    2

    Open a report based upon Query with Query preloaded

    I have a membership DB and I would like to open a report, using a command button, without having to Type Yes each time. The yes tells the program the person is financial. The Query search criteria is(Like '*'+[Type letter Y]+'*')

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    remove the parameter, "Type letter Y".
    and put "*Y*"

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

Similar Threads

  1. Replies: 3
    Last Post: 07-26-2016, 02:12 PM
  2. Replies: 1
    Last Post: 06-03-2014, 06:56 AM
  3. Help on report to open form to open query...
    By saseymour in forum Programming
    Replies: 13
    Last Post: 07-16-2013, 08:11 AM
  4. Open form based on query information
    By MFS in forum Programming
    Replies: 3
    Last Post: 06-11-2011, 12:44 PM
  5. Open form based on query results
    By RobbertH in forum Queries
    Replies: 1
    Last Post: 02-10-2010, 08:13 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
  •  
Other Forums: Microsoft Office Forums