Results 1 to 2 of 2
  1. #1
    geoffishere is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    10

    Query problems

    I have the attached database. I have set up the form frmsearch. This has a list of all leaders names. My plan is that the leaders come into the form put there name in and the query "modules query" runs. When a name is selected the query runs but come back with no information

    Any help woul be appreciated



    Cheers

    Geoff

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Your filtering on the wrong field; the cbo value is the ID, not the name. See the attached jpg.

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

Similar Threads

  1. Problems with run permissions on a query
    By admaldo in forum Queries
    Replies: 0
    Last Post: 05-09-2006, 09:04 AM
  2. Privileges problems whe executing a query
    By admaldo in forum Security
    Replies: 0
    Last Post: 04-27-2006, 07:22 AM
  3. Replies: 0
    Last Post: 04-24-2006, 06:48 AM
  4. Replies: 0
    Last Post: 04-21-2006, 06:55 AM
  5. Problems with a query in a list box
    By admaldo in forum Forms
    Replies: 1
    Last Post: 04-05-2006, 05:28 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